Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unique Entries

Status
Not open for further replies.

Krondor

Programmer
Oct 14, 2005
1
DE
Hi,

I've got a question.
I want to generate tables like this with powerdesigner:

create table TEST_TABLE
(
COL_1 integer not null,
COL_2 integer not null,
COL_3 integer not null,
COL_4 ...
...
primary key (COL_1),
unique (COL_2, COL_3)
);

Now I don't know how to create the unique-statement.
Is it possible to create unique attributes already in the ConceptualDataModels?
I've got PowerDesigner 12.0.0.1700.
 
You have to create an identifier for those attribute you want to be unique. Each table should have at least 1 identifier which is the PK but can also have others on different columns which creates a unique constraint when the physical model is generated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top