CREATE TABLE "COM_DATA"."T_MENU_PRIVILEGE"
( "PKID" NUMBER(16,0),
"ROLE_ID" VARCHAR2(16),
"MENU_ID" NUMBER(16,0),
"PRIVILEGE_ID" CHAR(3),
PRIMARY KEY ("PKID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
TABLESPACE "COM_DATA" ENABLE,
FOREIGN KEY ("ROLE_ID")
REFERENCES "COM_DATA"."T_ROLE" ("ROLE_ID") ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
TABLESPACE "COM_DATA"
select dbms_metadata.get_ddl('TABLE','T_MENU_PRIVILEGE') from dual;
sql
最新推荐文章于 2024-06-27 18:08:19 发布