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 the default port for MySQL Server?

1012

What is mysql_query?

794

Is mysql good for big data?

885

What is the hostname for mysql database?

950

Is mysql from oracle?

916

Explain Access Control Lists.

935

How do I rename a table in mysql workbench?

903

What is the use of mysqli_connect in php?

853

What is a left join mysql?

845

How do I run mysql on a mac?

892

What causes mysql too many connections?

875

What are the mysql database files stored in system ?

988

How large can a mysql database become?

916

What is a csv table?

946

How to get a list of columns in an existing table?

831