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

Why myisam is faster than innodb?

944

How do I run mysql?

1022

How many sql dml commands are supported by 'mysql'?

980

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2245

What language does mysql use?

916

How do I change global variables in mysql?

913

How do I change mysql password?

1029

Can we store pdf files in mysql?

995

What is mysql installer?

1001

What is 'mysqldump'?

1077

How to show table structure mysql?

1018

Can we write pl sql mysql?

954

How to start mysql server?

1069

Write a query to create a database and a table?

915

How to create a test table in your mysql server?

1055