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

2 votes305 views1 answer
Create mysql user on all hosts
SQL
0 vote269 views1 answer
Sql make sure every user is unqiuew
SQL
1 vote267 views1 answer
Postgresql last element of array
SQL
0 vote263 views1 answer
Uuid sqlalcomany
SQL
1 vote227 views1 answer
Oracle character set
SQL
0 vote228 views1 answer
Mysql convert column to uppercase
SQL
0 vote221 views1 answer
Mysql select top 2
SQL
36 votes298 views6 answers
Delete from where sql
SQL
0 vote265 views1 answer
Mysql show create db
SQL
0 vote274 views1 answer
Join creating duplicate columns sqllite
SQL