Interested to Buy Any Domain ? << Click Here >> for more details...
how to know the tables in database having foreign key?
- 2 Answers
- 4477 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 difference between mysql and mysqli?
How to drop an existing table in mysql?
how to display nth highest salary from a table in a mysql query? : Mysql dba
Is mysql same as mariadb?
What is difference between oracle sql and mysql?
What are the steps required to view your mysql database?
can you tell how can you display the maximum salary in sql? : Mysql dba
What is a data directory?
What is mysqli_num?
How many columns is too many mysql?
What is the difference Delete and Drop ?
What are the critical issues you have resolved in your company
-
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)
