Oracle Designer generation for Databases other than Oracle
I am trying to generate DDL from Oracle Designer for SQL Server and ANSI 92 databases.
We use Domains to define our databse columns.
When I generate the DDL for Oracle the Columns definitions get generated normally. But when I generate the same table for SQL Server, a datatype gets generated and then the column gets generated as the type. How can I generate the DDL that is similar to Oracle.
Example:
oracle scripts:
PROMPT Creating Table 'PCPC_AHFSCC' Creating Table 'PCPC_AHFSCC' CREATE TABLE PCPC_AHFSCC (AHFSCCCODE VARCHAR2 (8) NOT NULL ,DESCRIPTION VARCHAR2 (60) NOT NULL ) / PCPC_AHFSCC (AHFSCCCODE VARCHAR2 (8) NOT NULL