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 mysqlcommand?

479


How do I view a mysql database?

483


Why myisam is faster than innodb?

492


What is the data source name for mysql?

484


How to delete a column and add a new column to database

509






How to use regular expression in pattern match conditions?

527


What is the usage of "i-am-a-dummy" flag in mysql?

677


Does mysql use sql?

498


Why do we use mysql?

489


How do I zip a file in mysql?

546


Can you tell how to find the number of rows in a resultset using php?

477


How do I optimize a selected query in mysql?

516


Does mysql need a server?

496


What is difference between mysqli and pdo?

480


How do I change the max connection in mysql?

519