Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
show create table syntax in mysql

Featured

How to show CREATE TABLE syntax in MySQL?

Sometimes we need to check the CREATE TABLE syntax for already created table in the database. When we need to check what kind of columns and what datatype a column has in a table then we require the CREATE TABLE syntax for that table. Syntax ...

How to show the create table statement of a table in MySQL

To display the create table statement of a table in MySQL you need to execute the following command: use dbname; show create table tablename; But to view this statement you must have the privilege to access the table.
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: