Interested to Buy Any Domain ? << Click Here >> for more details...
how to know the tables in database having foreign key?
- 2 Answers
- 4580 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
Can you tell the difference between $message and $$message?
What tools available for managing mysql server?
What does mysql flush privileges do?
How would you enter characters as hex numbers?
How do I change the max connection in mysql?
How do I install mysql on windows 10?
Write a command to view mysql database table structure?
What is data node in mysql cluster?
Which is faster mysql or mongodb?
How do I truncate all tables in mysql?
How to start mysql server?
What is a blob datatype?
What port is mysql running on?
What is the difference between mysql_connect and mysqli_connect?
How to convert character strings to dates?
