Sql server create constraint

ALTER TABLE my_table ALTER COLUMN [Name] VARCHAR(50) NOT NULL;
ALTER TABLE my_table ADD CONSTRAINT UQ__Constrai UNIQUE (ID);
ALTER TABLE my_table ADD PRIMARY KEY (ID);
-- Get constraints names
SELECT CONSTRAINT_NAME,
     TABLE_SCHEMA ,
     TABLE_NAME,
     CONSTRAINT_TYPE
     FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
   WHERE TABLE_NAME='my_table';
ALTER TABLE my_table DROP CONSTRAINT PK__Constrai__xxxxx;

Similar codes

58 votes555 views4 answers
Mysql drop column
SQL
0 vote182 views1 answer
Sql developer search all packages for text
SQL
6 votes172 views2 answers
Find mysql version linux
SQL
0 vote188 views1 answer
Oracle change password expiration policy
SQL
0 vote191 views1 answer
Laravel migration sql dump
SQL
0 vote176 views1 answer
List column names of multiple tables psql
SQL
4 votes157 views1 answer
Sql list users and roles
SQL
22 votes180 views4 answers
Mysql date_format
SQL
0 vote193 views1 answer
Insert or update sql firebird
SQL
0 vote182 views2 answers
Pop sql insert value into
SQL