SHOW INDEX FROM mydb.mytable;

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

Question Posted / ashish tiwari

1 Answers
4266 Views
I also Faced
E-Mail Answers

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

849

Explain the architecture models of SQL Server?

2285

What is the data type for image?

1004

What are the advantages of mysql in comparison to oracle?

967

How we can get the current date in mysql?

903

What is mysql procedure?

885

What is flush privileges in mysql?

937

How to declare variable in mysql trigger?

925

How many rows can mysql hold?

832

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

938

How can I compare two mysql databases?

899

What are triggers mysql?

840

How to list or view all databases from the mysql server.

874

Explain what is mysql?

979

What is the difference between mysql and sql?

979