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 the difference between between and in operators in mysql?

1024

What is the size of mysql database?

931

How is oracle different from mysql?

1007

How do we delete a row in a table?

985

How to write optimized query in mysql?

983

How do I find users in mysql?

1095

What is meant by mysqli?

895

How can you export the table as an xml file in mysql?

874

How do I show columns in mysql?

922

explain GROUPBY & HAVING clause with examples.

2280

How is myisam table stored?

959

Explain about the architecture of MYSQL?

969

How can you handle the –secure-file-priv in mysql?

933

What is the purpose of mysql database?

917

How do I stop a mysql command?

982