show create table tbl_name; eg:- show create table tbl

What are the other commands to know the structure of table
using MySQL commands except explain command?

Question Posted / lekhraj deshmukh

Answer Posted / lekhraj deshmukh

show create table tbl_name;

eg:- show create table tbl_data;

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is save point in mysql?

898

What is truncate command?

874

What is 'mysqlimport'?

870

What is delimiter in mysql trigger?

897

Is postgresql better than mysql?

975

What are the types of index?

901

What is latest version of mysql?

946

What is meant by sharding?

866

What is tee command in mysql?

899

Which statement is used to delete a table in MySQL.

855

How do I stop a mysql service?

950

What is mysql default port number?

964

Where is mysql password stored?

873

What is limit in mysql?

824

What is delimiter in mysql stored procedure?

856