Database Administration (MOSC)

MOSC Banner

Oracle Designer generation for Databases other than Oracle

edited Mar 24, 2009 7:08AM in Database Administration (MOSC) 1 commentAnswered
 Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center