shilpak10

 Profile Answers by shilpak10 Questions by shilpak10

• May 2nd, 2007

 

DESC table_name will give the scheme of the table

sampra

 Profile Answers by sampra 

• Feb 14th, 2008

 

desc table_name

rockxy1214

 Profile Answers by rockxy1214 

• Feb 20th, 2008

 

Desc table is the shortest way

u can try this as well

SELECT * FROM `COLUMNS` where TABLE_NAME='' and TABLE_SCHEMA='';

sampra

 Profile Answers by sampra 

• Feb 20th, 2008

 

To get the structure data type constraint etc just type desc table-name;
It will give you all the information related to that particular table.

rockxy1214

 Profile Answers by rockxy1214 

• Feb 20th, 2008

 

ya that's right

desc table is easy to use

Think this way to desc a table,DB has to save the info some where right?
 its the information _schema DB where all the info related to Database or table is stored

internally desc will do the same as the below does

SELECT * FROM information_schema.`COLUMNS` where TABLE_NAME='' and TABLE_SCHEMA='';

trimurthy

• May 18th, 2012

 

you can also see the structure by using this statement "show create table table_name";

Thomas Freiling

• May 20th, 2016

 

DESCRIBE table_name

Rahul

• Jun 4th, 2016

 

DESC Table_name

Bhagya Killi

• Jun 13th, 2016

 

DESC TABLENAME will give you the structure of table

prakash s

• Nov 20th, 2017

 

describe tablename;