Designer

[13579]

How to generate table without primary key from Entity Relationship Diagram using Database Design Transformer

 

[JFlack]

You can't. The transformer checks to see if you designated a primary or unique key for the entity, and if you didn't, it creates a numeric field to be a surrogate primary key (named entityname_id) and a sequence (named entityname_seq) to populate it. If this isn't what you want to happen, then let it do its work, then force delete the column description, primary key, and sequence description. That is one of the great things about Designer - the physical design is not constrained by the logical design.

But think twice before you do - the generators REALLY need a primary key in order to generate modules to update a table.

 

[13579]

Thanks.But one of my friends says,u can generate table without having primary key or surrogate key.also can i stop those unneccessary sequences.