Sql

Search

unique key in ms sql server

/* To create the Unique Key.
Unique Key constraint to enforce uniqueneess of a column i.e. the column 
shouldn't allow duplicate values.*/
ALTER TABLE Table_Name
ADD CONSTRAINT Constraint_Name UNIQUE (Column_Name)

Comment

PREVIOUS	NEXT

Code Example
Sql :: combine 2 columns search query mysql
Sql :: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Sql :: delete row by id mysql
Sql :: sql integer to serial
Sql :: select random rows sql
Sql :: sql query to find percentage of null values in a table
Sql :: what is a query in sql
Sql :: SQL COUNT() With HAVING Clause
Sql :: date sql
Sql :: Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
Sql :: insert in to table sql
Sql :: to_char sql
Sql :: update column value in sql
Sql :: SQL COUNT() with WHERE
Sql :: Get all index postgres
Sql :: select true if exists on another table or false sqlserver
Sql :: oracle previous year
Sql :: postgres describe table
Sql :: postgresql change user role grant
Sql :: sql last time database was accessed
Sql :: date get month number sql
Sql :: select case when oracle
Sql :: between vs in sql
Sql :: postgres parent and child tables
Sql :: sql join
Sql :: sql order by with where
Sql :: execut sql python
Sql :: mysql into outfile with headers
Sql :: sql sum of same record
Sql :: local database sql

Search

SQL

unique key in ms sql server

ADD CONTENT