Toad World® Forums

Extract DDL


#1

Most of my tables consist in a primary key which is on two columns (ID_FIRMA, ID) (see image).
Even if this columns are set to NOT NULL, when extracting the DDL it shows the table creation script but without NOT NULL for ID column. (see below)

*-- Start of DDL Script for Table TOTAL.TEST
– Generated 10/01/2011 16:22:30 from …CREATE * TABLE test
(id_firma NUMBER(20,0) NOT NULL,
id NUMBER(20,0) ,
other_column VARCHAR2(10 BYTE))
PCTFREE 10
INITRANS 1
MAXTRANS 255
TABLESPACE users
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
)
NOCACHE
MONITORING
NOPARALLEL
LOGGING
/

e_ddl_err.png


#2

Thank you for reporting this. It is a bug in SQL Navigator.
This occurs when the column name is part of the first column name’s.
like:
CREATE TABLE test_customer
(id_firma NUMBER(20,0) NOT NULL,
id NUMBER(20,0) ,
id_f VARCHAR2(10 BYTE) ).
‘id’ & ‘id_f’ is part of ‘id_firma’, So both ‘id’ and ‘id_f’ don’t show not null when extract ddl, even though they are set to ‘not null’.
Will create a CR for this and fix it soon.

Regards
Lyla Su

Message was edited by: Lyla