Show Create Statement For A Table
In MySQL, you can get a quick rundown of a table using describe users
. An alternative to this approach is to have MySQL show the create
statement for a table.
This includes some additional information like primary key and index information. It is also a great way to study the SQL that it takes to create all the facets of a table.
See the show create table
docs for more details.
h/t Jake Worth
Last updated