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

0 vote283 views1 answer
Select from 3 tables one is empty
SQL
0 vote242 views1 answer
Online sql compiler
SQL
2 votes305 views1 answer
Mariadb json select
SQL
19 votes306 views6 answers
Create table sqlite
SQL
12 votes321 views5 answers
Rename table in mysql
SQL
3 votes307 views1 answer
Oracle function return
SQL
1 vote305 views1 answer
Create new table from old table with data
SQL
0 vote329 views1 answer
Oracle decode
SQL
2 votes330 views1 answer
Create mysql user on all hosts
SQL
1 vote287 views1 answer
Mysql limit results to 10
SQL