Interested to Buy Any Domain ? << Click Here >> for more details...
how to know the tables in database having foreign key?
- 2 Answers
- 4394 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
Do I need python for mysql?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
Explain triggers and stored procedures?
How to represent ENUMs and SETs internally?
What is the difference between MyISAM Static and MyISAM Dynamic?
What is difference between microsoft sql and mysql?
How do I know if mysql is running on windows?
How do I start mysql client?
What is dblink?
how to Return total number of rows.
How can you plan the logshipping before processing?
How to drop an existing table in mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What are the applications required to support mysql?
Explain Access Control Lists.
