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

Create table employee (eno int(2),ename varchar(10)) ?

How to display nth highest salary from a table in a mysql query?

What is the data source name for mysql?

What is dump in mysql?

How to get a list of columns in an existing table?

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

How to include numeric values in sql statements?

What is the difference between mysql and sql?

What is mysql_query?

What is text?

How can we optimize stored procedure?

Which is faster innodb or myisam?

For more MySQL Interview Questions Click Here