Interested to Buy Any Domain ? << Click Here >> for more details...
how to know the tables in database having foreign key?
- 2 Answers
- 4386 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is text in mysql?
Does mysql automatically index foreign keys?
How do I find my mysql username and password?
What is the difference between truncate and delete in mysql?
What is sqlyog?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
How to use mysqldump to create a copy of the database?
What is the datatype of image in mysql?
What are the purposes of using enum and set data types?
List some mysql advantages and disadvantages?
Is Mysql query is case sensitive?
How internally data stores in MyISAM and INNODB table types?
how to Return total number of rows.
Does mysql use sql?
How do you kill a long running query in mysql?
