Interested to Buy Any Domain ? << Click Here >> for more details...
how to know the tables in database having foreign key?
- 2 Answers
- 4385 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 save in mysql?
What is processlist in mysql?
What is max_used_connections in mysql?
How would concatenate strings in mysql?
Where is mysql used?
What are the advantages and disadvantages of using mysql?
How many ways to get the current time?
Is mysql a distributed database?
What is procedures in mysql?
What you can use regular expression for in mysql? Support your answer with an example?
How many columns can be used for creating Index?
How can you calculate the sum of any column of a table?
-
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)
