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



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

Answer / ashish tiwari

SHOW INDEX FROM mydb.mytable;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More MySQL Interview Questions

Which statement is used to delete a table in MySQL.

0 Answers  


How can you count the total number of records of any table?

0 Answers  


Is mysql and sql are same?

0 Answers  


What are numeric data types?

0 Answers  


What is the difference between mysql_connect() and mysql_pconnect()?

7 Answers   TCS,






Is mysql a odbc?

0 Answers  


Can you tell what are various ways to create an index?

0 Answers  


Is pdo faster than mysqli?

0 Answers  


Where’s database data actually stored?

0 Answers  


What is mysqlcommand?

0 Answers  


What ascii 31?

0 Answers  


What is the maximum no of columns a table can have?

0 Answers  


Categories