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

1 Answers
4351 Views
I also Faced
E-Mail Answers

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

what if you really want to store the timestamp data, such as the publication date of the article?

2 Answers

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

0 Answers

How to delete the repeated records from a table?

0 Answers

Is sql similar to mysql?

0 Answers

Can mysql store files?

0 Answers

What is a crosstab query?

0 Answers

How do I restore a mysql database dump file in linux?

0 Answers

What are the functions of mysql?

0 Answers

what is the querry for all managers salary?

2 Answers

What are the non-standard sql commands supported by 'mysql'?

0 Answers

What is different between sql and mysql?

0 Answers

For more MySQL Interview Questions Click Here