How will we see framework of a table?
Answers were Sorted based on User's Feedback
Answer / yam
to see the framework of table use
DESCRIBE tablename;
or DESC tablename
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / sudheer kumar mikkilineni
select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;
| Is This Answer Correct ? | 12 Yes | 0 No |
What is dialect in sql?
write a query to delete similar records in particular fields(columns) in different tables
How do I find duplicates in sql?
what are the different type of normalization? : Sql dba
What is java sql package?
How to get the procedure's, function's name from a package if it is wrapped(both spec & body).
how to connect oracle in unix prompt?
What does t sql mean?
How to select all records from the table?
Does sql view stored data?
Does pdo prevent sql injection?
can i use global variables in stored procedure or function
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)