how to know the tables in database having foreign key?
- 2 Answers
- 3553 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 the command line end user interface - mysql?
How do I edit a trigger in mysql?
What is a table schema?
How do I create a stored procedure in mysql?
Where the database is stored in mysql?
What are the differences between char and nchar?
How do I stop a mysql service?
What's the latest version of mysql?
what is the advantage of stored procedures, triggers and indexing in mysql
How many columns is too many mysql?
What is the full meaning of mysql?
How to decrement dates by 1 in 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)
