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

How to see the create table statement of an existing table?

Question Posted / sulabh shukla


How to see the create table statement of an existing table?..

Answer / Shivam Shukla

'SHOW CREATE TABLE tablename;'

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How can you see all indexes defined for a table?

1 Answers  

How do I remove a user from mysql?

1 Answers  

How to write optimized query in mysql?

1 Answers  

What is the function of mysqldump?

1 Answers  

How to install mysql?

1 Answers  

How to delete the repeated records from a table?

1 Answers  

What is MySQL?

1 Answers  

What is mysql primary key?

1 Answers  

How to start mysql server?

1 Answers  

How to validate email addresses in mysql?

1 Answers  

What is mysql good for?

1 Answers  

What is a result set object?

1 Answers  

For more MySQL Interview Questions Click Here
Categories