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 is difference sql and mysql?

535

Is sql a programming?

547

How do I upgrade sql?

551

What are the 3 modes of parameter?

682

how to create a new table by selecting rows from another table in mysql? : Sql dba

563

How do you create a db file?

523

What is a procedure in pl sql?

550

What are the advantages of sql? Explain

650

Is left join faster than join?

549

what is view? : Sql dba

558

How do you remove duplicate records from a table?

511

Which query operators in sql is used for pattern matching?

546

How would you reference column values before and after you have inserted and deleted triggers?

622

What are the types of queries in sql?

524

Can pl sql procedure have a return statement?

552