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

What language is used in mysql?

0 Answers  


How triggers can be used in mysql?

0 Answers  


What does blob mean in mysql?

0 Answers  


Is mysqli deprecated?

0 Answers  


What are the features of Stored Procedures in MYSQL?

1 Answers  


What is the difference between char and varchar?

0 Answers  


What is timestamp in mysql?

0 Answers  


Is mysql still popular?

0 Answers  


What is the default port for mysql and how it can change?

0 Answers  


How to create a trigger in mysql?

0 Answers  


How do I kill a mysql connection?

0 Answers  


when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  


Categories