How to view table structure sql query?

Question

I want to make a new table like as an existing table in MySQL database with some "column name" changes. So, is there any way to see the SQL dump of the existing table without importing?

Nick · Accepted Answer · 2019-05-02 07:52:19Z

2

You can use SHOW CREATE TABLE:

SHOW CREATE TABLE oldtable

answered May 2, 2019 at 7:52

Nick

147k23 gold badges67 silver badges106 bronze badges

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

2 Comments

Nick Over a year ago

@P.Salmon it's hard to say. Just reading the question, you might be right, but the title definitely suggests this is the answer.

imrvasishtha Over a year ago

yeah, @Nick that's helpful.

Collectives™ on Stack Overflow

How to view table structure sql query?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related