Saturday, January 15, 2011

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Answers:

Yes, you can have a column for Primary key and have another column which will have no duplicates or null.e.g.A Salary Table will have employee ID as primary key.
The table also contains TAX-ID which can not be null or duplicate

No comments:

Post a Comment