how to know the tables in database having foreign key?
- 2 Answers
- 3982 Views
- I also Faced
- E-Mail Answers
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
Which command is used to view the content of the table in mysql?
What is mysql port?
What is the command used to create a database using php and mysql?
Does mysql support nosql?
What is sql vs mysql?
What is the password of mysql?
Write a query to find duplicate rows in table?
What data structure does mysql use?
How do I view mysql logs?
Where is the mysql database stored?
Which is better sqlite or mysql?
What is a blob datatype?
How do I run mysql?
What is the role of a limit in a mysql query?
How can you add and remove any column of a table?
