DESC <tableName> This will give you all property of table. Where K

how to know the tables in database having foreign key?

Question Posted / rahul

Answer Posted / rahul

DESC <tableName>

This will give you all property of table. Where Key column show you key description.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is mysql_query?

850

What does mysql flush privileges do?

927

What mysql means?

933

How do I backup mysql database on linux?

925

What is timestamp in mysql?

980

How do you kill a long running query in mysql?

886

How to get the current date in mysql?

1052

What is difference between mysql and mysql server?

985

How do I optimize a selected query in mysql?

925

What do I do if I forgot my mysql root password?

895

What is max_used_connections in mysql?

946

What is a trigger? How you can create a trigger in mysql?

893

How do I copy an entire mysql database?

885

How many triggers are possible in mysql?

964

What are federated tables?

1173