how to know the tables in database having foreign key?
- 2 Answers
- 3582 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 a blob datatype?
What is session variable in mysql?
How many rows can a mysql table hold?
What is clob datatype?
How do I change a procedure in mysql?
How do I insert an image into mysql workbench?
How do I show users in mysql?
Where is mysql used?
How database are managed?
What is the data type for file in mysql?
How to enter microseconds in sql statements?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
