Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

constraint unique sql

ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col_name); 
ALTER TABLE table_name ADD CONSTRAINT cst_name UNIQUE (col1, col2); -- Multiple
ALTER TABLE table_name ADD col_name NUMBER UNIQUE;				  	-- New field
Source by www.oracletutorial.com #
 
PREVIOUS NEXT
Tagged: #constraint #unique #sql
ADD COMMENT
Topic
Name
2+8 =