how to know the tables in database having foreign key?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways we can retrieve the date in result set of mysql using php?

522


Is mysqli secure?

480


What is the use of procedure in mysql?

475


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

1548


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1553






What is blob and text in mysql?

608


How can you filter the duplicate data while retrieving records from the table?

472


What is default schema in mysql?

482


What is blob in mysql?

492


What is the usage of regular expressions in mysql?

487


What is pdo in php mysql?

494


How do I install mysql workbench?

475


How many columns can a table have?

481


Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

580


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

570