Saturday, August 27, 2011

Adding a UNIQUE Constraint to an Existing Table

Alter tablename add constraint constraint_name constrainttype (columnname)

example: Alter employee add constraint uk_empcode unqiue(empcode)

No comments: