Answers for "unique constraint in oracle"

SQL
7

oracle unique constraint

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
Posted by: Guest on July-03-2021
1

unique constraint mssql

USE AdventureWorks2012;  
GO  
CREATE TABLE Production.TransactionHistoryArchive4  
 (  
   TransactionID int NOT NULL,   
   CONSTRAINT AK_TransactionID UNIQUE(TransactionID)   
);   
GO
Posted by: Guest on August-03-2020

Code answers related to "unique constraint in oracle"

Code answers related to "SQL"

Browse Popular Code Answers by Language