how to know the tables in database having foreign key?

Question Posted / laxmiprasanna06

2 Answers
4508 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to know the tables in database having foreign key?..

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

how to know the tables in database having foreign key?..

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

Post New Answer

More MySQL Interview Questions

Do while loop in mysql procedure?

0 Answers

How to show table structure mysql?

0 Answers

What does innodb stand for?

0 Answers

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 Answers

What is trigger in mysql?

0 Answers

What is save point in mysql?

0 Answers

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers Afixi, GE,

What is Database?

2 Answers

How can you move the master database

0 Answers IBM,

Is mysql a programming language?

0 Answers

What are the 'mysql' command line arguments?

0 Answers

what is cte? : Mysql dba

0 Answers

For more MySQL Interview Questions Click Here