How Can I Get the Equivalent of MySQL's 'SHOW CREATE TABLE' in Oracle SQL?

Oracle SQL Equivalent for "Show Create Table"

In MySQL, the show create table command provides information about the structure and constraints of a table. Is there a similar functionality available in Oracle SQL?

SQL*Plus Command

If referencing SQL*Plus commands, the equivalent to show create table is the desc command. It displays the following details for each column in the table:

• Name
• Data type
• Null constraint

Example:

SQL> desc emp;

SQL Statement

For a direct SQL statement, the DBMS_METADATA package can be utilized:

SELECT dbms_metadata.get_ddl('TABLE', 'EMP') FROM dual;

This query returns a CREATE TABLE statement that includes all the column definitions, constraints, and storage parameters for the EMP table.

Note:

• If the DDL is particularly long, use the set long command to display more results: set long 10000.
• The DBMS_METADATA.GET_DDL function requires the object_privilege metadata privilege on the table.

The above is the detailed content of How Can I Get the Equivalent of MySQL's 'SHOW CREATE TABLE' in Oracle SQL?. For more information, please follow other related articles on the PHP Chinese website!