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

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

Question Posted / melaniewebdesign

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

More MySQL Interview Questions

Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr

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

Can't connect mysql server on localhost?

What is max_used_connections in mysql?

When to use order by in delete statement?

What is the difference between the primary and unique key in mysql?

How do I find mysql version in mysql workbench?

Tell us something about heap tables?

can you tell how can you display the maximum salary in sql? : Mysql dba

What is database in php mysql?

How to escape special characters in sql statements?

What are the advantages of stored procedures, triggers, indexes?

For more MySQL Interview Questions Click Here