查询表信息
功能
查询表的列信息，包括列名、是否为空和列类型。
关键字
DESC
用法
DESC 表名示例
sql
SQL> DESC sys_tables;
Column_Name NULL Data_Type
------------------------------------------------------------------------------
DB_ID | | INTEGER
USER_ID | | INTEGER
SCHEMA_ID | | INTEGER
TABLE_ID | | INTEGER
TABLE_NAME | | CHAR(128)
TABLE_TYPE | | INTEGER
TEMP_TYPE | | INTEGER
FIELD_NUM | | INTEGER
PARTI_TYPE | | INTEGER
PARTI_NUM | | INTEGER
PARTI_KEY | | CHAR(1024)
AUTO_PARTI_TYPE | | INTEGER
AUTO_PARTI_SPAN | | INTEGER
SUBPARTI_TYPE | | INTEGER
SUBPARTI_NUM | | INTEGER
SUBPARTI_KEY | | CHAR(1024)
GSTO_NO | | INTEGER
COPY_NUM | | INTEGER
BLOCK_SIZE | | INTEGER
CHUNK_SIZE | | INTEGER
RECORD_NUM | | BIGINT
PCTFREE | | INTEGER
HOTSPOT_NUM | | INTEGER
USE_CACHE | | BOOLEAN
ONLINE | | BOOLEAN
IS_SYS | | BOOLEAN
IS_ENCRY | | BOOLEAN
SLOW_MODIFY | | BOOLEAN
XLS_PID | | INTEGER
XLS_COL_NO | | INTEGER
XLS_COL_OPT | | INTEGER
ON_COMMIT_DEL | | BOOLEAN
ENA_TRANS | | BOOLEAN
ENA_LOGGING | | BOOLEAN
REG_MODIFY | | BOOLEAN
VALID | | BOOLEAN
ACL_MASK | | INTEGER
AUTO_PARTI_NO | | INTEGER
CREATE_TIME | | DATETIME
COMMENTS | | CHAR(128)
ANA_POLICY | | INTEGER
ANA_PERIOD | | INTEGER
ANA_THRESHOLD | | INTEGER
ANA_LEVEL | | INTEGER
ENCRY_ID | | INTEGER
STO_ZONE | | INTEGER
CACHE_HASH_KEY | | CHAR(1024)
COMPRESS_LEVEL | | INTEGER
RESERVED5 | | CHAR(128)