how to know the tables in database having foreign key?
Answer Posted / sudhanshu_kmr
use this .....
show create table <tablename>;
it will describe all the properties of the table.
here <tablename> is name of table for which u want to know about.
for example-
SHOW CREATE TABLE STUDENT;
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What are the different column comparison operators in mysql?
What are the functions of mysql?
What is unsigned int in mysql?
Is mysql port 3306 tcp or udp?
How to set the time zone for MySQL to particular country time?
What is mysqli_result?
What is the latest version of php and mysql?
How to check if a record exists in a mysql database php?
Is mongodb faster than mysql?
What is blob in mysql?
What is the command line end user interface - mysql?
What is new mysqli?
How you will show all data from a table.
How do I download a mysql community server?
How do I export mysql query results to excel?