How to get table syntax ( Query ) in mysql?

Question

Rather than getting table structure (DESC tablename;) Is there any possibility to get table syntax (query) in mysql ?

Mike Brant · Accepted Answer · 2013-12-23 18:24:25Z

1

I assume you are asking for this:

SHOW CREATE TABLE table_name

This will show you an SQL statement that could be used to create the table schema.

answered Dec 23, 2013 at 18:24

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul Tripathi · Accepted Answer · 2013-12-23 18:24:51Z

1

Try this

SHOW CREATE TABLE tablename

You may check out SHOW CREATE TABLE Syntax

Shows the CREATE TABLE statement that creates the named table. To use this statement, you must have some privilege for the table. As of MySQL 5.0.1, this statement also works with views.

answered Dec 23, 2013 at 18:24

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Collectives™ on Stack Overflow

How to get table syntax ( Query ) in mysql?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related