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 vote207 views1 answer
Mssql last day of month
SQL
0 vote290 views5 answers
Right join
SQL
0 vote190 views1 answer
Mariadb maximum left join
SQL
1 vote221 views1 answer
Oracle drop temporary table
SQL
6 votes166 views1 answer
Phpmyadmin reset root password
SQL
3 votes174 views3 answers
Mysql get table size
SQL
-1 vote178 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
1 vote191 views1 answer
Partition by sql server
SQL
3 votes172 views3 answers
Mysqldump: couldn
SQL
0 vote179 views1 answer
Count characters of string mysql
SQL