Getting Information on Tables

You can get information about your tables by

Performing a DESCRIBE command on the table.
Querying the user_tables view.

Some of the columns in the user_tables view:

Column	Type	Description
table_name	VARCHAR2(30)	Name of the table.
tablespace_name	VARCHAR2(30)	Name of the tablespace
temporary	VARCHAR2(1)	Whether the table is temporary.


SQL> SELECT table_name, tablespace_name, temporary
  2  FROM user_tables
  3  WHERE table_name IN ('MYTABLE');

TABLE_NAME                     TABLESPACE_NAME                T
------------------------------ ------------------------------ -
MYTABLE                                                       Y

SQL>

Home »
Oracle »
Table »

Table Creation:

Creating a Table
Getting Information on Tables
Information on Columns in Tables
Renaming a Table
Truncating a Table
Dropping a Table