how to know the tables in database having foreign key?
- 2 Answers
- 3944 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is dblink?
What is select query in mysql?
Can't connect mysql server on localhost?
Can I install mysql on mac?
What is an index? How can an index be declared in mysql?
What is myisamchk?
What is delimiter in mysql?
How to dump one database for backup.
What is the difference between a database and a table?
How do you start MySQL on Linux?
Can you tell the difference between $message and $$message?
What is max_used_connections in mysql?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
