Interested to Buy Any Domain ? << Click Here >> for more details...
how to know the tables in database having foreign key?
- 2 Answers
- 4493 Views
- I also Faced
- E-Mail Answers
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
What is a user defined variable?
What is a result set object?
How do you determine the location of mysql data directory?
Can we store videos in mysql database?
Does mysql use tcp or udp?
What is the maximum number of records in mysql table?
What are the different data types in mysql?
How can you change the password of a mysql user?
What is striped backup
Explain the difference between delete and truncate.
Is mysql open source?
Is mysql free download?
can you tell how can you display the maximum salary in sql? : Mysql dba
Is mysql same as sql?
How to upload a large file through phpmyadmin in mysql?
