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?

Answer 1

You can use SHOW CREATE TABLE:

SHOW CREATE TABLE oldtable