how to know the tables in database having foreign key?
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
Do you need a license for mysql?
What are the types of queries?
How do I show all mysql databases?
What is a string in mysql?
How to show all tables with 'mysql'?
How to determine the location of the data directory?
How to convert character strings to dates?
What are the difference between now and current_date in mysql?
Does mysql use t sql?
Do while loop in mysql procedure?
How to write date and time literals?
What are the functions in mysql?
What is a crosstab query?
How to enter binary numbers in sql statements?
What is data type for image in mysql?