Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database / What is UNIQUE KEY constraint?

What is UNIQUE KEY constraint?
Print
Email to friend
Add comment
Views: 57
Votes: 0
Comments: 0
A UNIQUE constraint enforces the uniqueness of the values in a set of columns, so no duplicate values are entered. The unique key constraints are used to enforce entity integrity as the primary key constraints.
Others in this Category
document What is Row_Number()?
document When is the use of UPDATE_STATISTICS command?
document What are the properties of the Relational tables?
document What is Difference between Function and Stored Procedure?
document Q: What is the meaning of data definition name (ddname) and dataset name (dsname) in the DD statement?
document What are the difference between clustered and a non-clustered index?
document What’s the difference between a primary key and a unique key?
document Q: Emp table had an employee with salary 2000. I issued an update statement to set the salary to 3000. Then I issued a create table statement. However the create table command errored out. I want to rollback the earlier update statement. Can I do that?
document What is the STUFF function and how does it differ from the REPLACE function?
document What are the different index configurations a table can have?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)