Search
 
SCRIPT & CODE EXAMPLE
 

SQL

add unique constraint sql server multiple columns

ALTER TABLE dbo.User
  ADD CONSTRAINT ucCodes UNIQUE (fcode, scode, dcode)
Comment

sql server add unique constraint two columns

CREATE UNIQUE INDEX uq_yourtablename
  ON dbo.yourtablename(column1, column2);
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql create timestamp column 
Sql :: mysql alter decimal precision 
Sql :: how to reset table in sql server 
Sql :: get only first row mysql 
Sql :: not operator in oracle 
Sql :: date in where on datetime column clause mysql 
Sql :: mysql remove only_full_group_by permanently 
Sql :: mysql add fields 
Sql :: docker mysql random root password 
Sql :: wordpress print query sql 
Sql :: insert all in sql 
Sql :: how to drop a database in sql server when it is in use 
Sql :: scaffold mysql database 
Sql :: t sql to rebuild all indexes in a database 
Sql :: convert rows to columns in sql server 
Sql :: contains word in sql 
Sql :: Suse Linux restart MySQL 
Sql :: flask sqlalchemy default value 
Sql :: sql server substring 
Sql :: SQL Server Get the current identity value of the table 
Sql :: delete dublicate rows sql 
Sql :: sql view where tables have same column name combine results 
Sql :: create table in mysql 
Sql :: postgresql create user 
Sql :: mac install mysql 
Sql :: mysql database create 
Sql :: sql delete row with auto increment 
Sql :: postgresql add leading zeros 
Sql :: run mysql file in terminal 
Sql :: how to create a table in mysql 
ADD CONTENT
Topic
Content
Source link
Name
6+9 =