1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / melaniewebdesign


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

How are mysql timestamps seen to a user?

0 Answers  

What is current version of mysql?

0 Answers  

What is an index? How can an index be declared in mysql?

0 Answers  

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

0 Answers  

How to show table names with 'mysqlshow'?

0 Answers  




What does "i_am_a_dummy flag" do in mysql?

0 Answers  

How can you make a database as your current database?

0 Answers  

Give string types available for column?

0 Answers  

How to insert dynamic values in mysql using php?

0 Answers  

What is trigger in mysql?

0 Answers  

What is the maximum number of columns per table?

0 Answers  

How do I update a variable in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories