A custom version of the DDL Wizard can wrap the DDL output with any valid HTML formatting.

DDL Source for
TABLE TEST.DT_TEST.EMP

[ DB TEST Contents ][ Schema DT_TEST Contents ][ All DT_TEST TABLES ]
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" ;

[ DB TEST Contents ][ Schema DT_TEST Contents ][ All DT_TEST TABLES ]

© Copyright 2017. All rights reserved Net 2000 Ltd.