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

Answer Posted / ashish tiwari

SHOW INDEX FROM mydb.mytable;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is join in mysql? What are the different types of join?

578


What are procedures in mysql?

582


What is mysql data directory?

601


What is root password?

550


What is pdo mysql?

580






How to calculate the difference between two dates?

582


What is a crosstab query?

599


Does adding an index lock a table?

583


How do you insert a table?

577


What is the default port of mysql server?

599


What is triggers and how it can be used in mysql?

599


What is the default port number of mysql?

589


Do while loop in mysql procedure?

647


What is data type for image in mysql?

540


What is mysql_pconnect?

553