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

-1 vote176 views10 answers
Delete Query in SQL Server
SQL
6 votes202 views2 answers
Join vs union
SQL
6 votes222 views3 answers
Update with inner join postgres
SQL
0 vote190 views1 answer
Wordpress sql find and replace
SQL
1 vote166 views1 answer
Restart identity postgresql
SQL
0 vote226 views1 answer
Having all mysql
SQL
2 votes215 views1 answer
Sql find not in list
SQL
0 vote199 views1 answer
Minecraft duping allowed servers
SQL
0 vote205 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote204 views1 answer
Python sqlalchemy orm to select null values
SQL