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

Is mysql a scripting language?

901

How to rename an existing table in mysql?

1033

Is mysql written in c?

902

How many columns is too many mysql?

907

What are the disadvantages of mysql?

1073

What is database migration in mysql?

1023

What language is mysql written in?

990

Can mysql handle big data?

955

What are the similarities between a function and a procedure?

896

How to insert html code into mysql database using php?

1078

How do I restore a mysql database?

1086

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1122

What is query log in mysql?

982

What does mysql flush hosts do?

890

What is insert query in mysql?

909