teradata 查看 表定义_查看表定义语句

SQL&gt set pages 0

SQL&gt set long 1000000

SQL&gt select dbms_metadata.get_ddl('TABLE','表名','用户名') from dual;

select dbms_metadata.get_ddl('TABLE','ACCESS_SERVER','MEGAEYES') from dual;

"(CLOB)

CREATE TABLE "MEGAEYES"."ACCESS_SERVER"

("ID" VARCHAR2(31) NOT NULL ENABLE,

"OPTIMISTIC_LOCK" NUMBER(19,0) NOT NULL ENABLE,

"F_NAME" VARCHAR2(255),

"NAMING" VARCHAR2(255),

"INSTALL_LOCATION" VARCHAR2(255),

"DEVICE_NUMBER" VARCHAR2(255) NOT NULL ENABLE,

"NOTE" VARCHAR2(255),

"IP" VARCHAR2(255),

"O_ORGAN_ID" VARCHAR2(31) NOT NULL ENABLE,

"STD_ID" VARCHAR2(32),

"IP1" VARCHAR2(16),

PRIMARY KEY ("ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

TABLESPACE "MEGASPACE" ENABLE,

UNIQUE ("DEVICE_NUMBER")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

TABLESPACE "MEGASPACE" ENABLE,

CONSTRAINT "FK559FDE7EE52BDC19" FOREIGN KEY ("O_ORGAN_ID")

REFERENCES "MEGAEYES"."O_ORGAN" ("ID") ENABLE

) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING

STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

TABLESPACE "MEGASPACE"

"