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

When sql appeared?

613

How to sort the rows in sql.

597

How to avoid duplicate records in a query?

575

What is string data type in sql?

527

How do you create an update query?

515

Why is partition used in sql?

545

How do rank () and dense_rank () differ?

514

What do you mean by “trigger” in sql?

613

How do you get column names only for a table (sql server)?

663

What is the sql case statement?

568

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

527

Differentiate between syntax and runtime errors.

637

what is table? : Sql dba

570

What are sql indexes?

541

Is big data nosql?

512