Rasshu
Reputation: 1799
Retrieve CREATE TABLE code of an already existing table?
Is there a way to do this?
In case the DBMS command history got cleaned or, in my case, when many ALTER TABLE were used in the course of time.
I'm using MySQL.
Upvotes: 1
Views: 158
Answers (1)
Michael Berkowski
Reputation: 270637
Yes, it is as simple as
SHOW CREATE TABLE yourtable;
This will include all the subsequent ALTER TABLE statements. You cannot retrieve the table's original state.
Here is the relevant documentation
Upvotes: 6
Related Questions
- How to generate a create table script for an existing table in phpmyadmin?
- mysql "create table if not exists", determine if table created
- Is there a 'SHOW CREATE TABLE' for another query
- how can I get the sql statements used to create a specific table?
- Create MySQL query to create a table from an existing table
- Reconstruct Create-Table-statement from Select-Statements
- SQL create table code
- Debugging MySQL CREATE TABLE from existing table statement?
- Is it possible to pull a table's create syntax via mysql?
- generate a "create table" sql command based on an existing table in mysql