DDL Code
- A custom version of the DDL Wizard can wrap the DDL output with any
valid HTML formatting.
|
CREATE TABLE "EMP"
(
"EMPNO" NUMBER(4, 0),
"ENAME" VARCHAR2(10),
"JOB" VARCHAR2(9),
"MGR" NUMBER(4, 0),
"HIREDATE" DATE,
"SAL" NUMBER(7, 2),
"COMM" NUMBER(7, 2),
"DEPTNO" NUMBER(2, 0)
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE(INITIAL 131072
NEXT 131072
MINEXTENTS 1
MAXEXTENTS 4096
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
DDL Dependent on TABLE DT_TEST.EMP
- Indexes
- PK_EMP
- Const(PK)s
- EMP
- Child FKs
- EMP
- On Grants
- GRANT INSERT ON "EMP" TO PUBLIC WITH GRANT OPTION ;
- GRANT SELECT ON "EMP" TO PUBLIC WITH GRANT OPTION ;
- Comments
- COMMENT ON COLUMN "EMP"."ENAME"
IS 'this is a comment on the ename column of the emp table';
- Synonyms
- CREATE SYNONYM "SYN_EMP"
FOR "EMP" ;
|