to see the framework of table use DESCRIBE tablename; or DESC tablename

How will we see framework of a table?

Question Posted / yam

Answer Posted / yam

to see the framework of table use

DESCRIBE tablename;
or DESC tablename

Is This Answer Correct ?

20 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are the advantages of mysql in comparison to oracle? : Sql dba

1049

what is the stuff function and how does it differ from the replace function? : Sql dba

1109

how to fetch alternate records from a table? : Sql dba

1172

Can triggers stop a dml statement from executing on a table?

1160

what are the differences between require and include, include_once and require_once? : Sql dba

1071

Write a sql select query that only returns each name only once from a table?

1078

How to create an array in pl/sql?

1123

How do you update a value in sql?

1103

How do I create a memory optimized filegroup?

1012

What is the use of desc in sql?

1022

what are the security recommendations while using mysql? : Sql dba

1181

What is a trigger in sql?

1235

Can we create a trigger on view?

946

how to start mysql server? : Sql dba

1239

what is meant by nl2br()? : Sql dba

1107