Interested to Buy Any Domain ? << Click Here >> for more details...
how to know the tables in database having foreign key?
- 2 Answers
- 4484 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 |
How do I flush privileges in mysql?
What does "i_am_a_dummy flag" do in mysql?
What is difference between group by and order by clause?
What is procedures in mysql?
What is a deterministic function?
Which is better mysql or microsoft sql?
Explain about the architecture of MYSQL?
What is Database?
Consider you have the following three tables which have to be linked together.
Can mysql scale horizontally?
How to get current MySQL version?
What is the usage of "i-am-a-dummy" flag in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
