how do i list constraints in my database by using sql
server2000?

Answer Posted / ashish tiwari

SHOW INDEX FROM mydb.mytable;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between mongodb and mysql?

955


What is pdo mysql?

700


What is mysql community server?

692


Is mysql running ubuntu?

679


What is mysql good for?

656


Where is mysql data stored linux?

699


How MySQL Optimizes DISTINCT?

809


What do you mean by % and _ in the LIKE statement?

755


What is innodb_buffer_pool_size?

696


What are the two types of queries?

660


What is current version of mysql?

697


Write a command with which mysql table can be repaired

735


How to see table's field formats or description of table .

663


Is mysql a good database?

689


what is the default port for mysql server? : Mysql dba

757