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 vote171 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote200 views1 answer
Sql out file formate
SQL
2 votes238 views3 answers
Mysql kill
SQL
3 votes179 views2 answers
Postgres inner join vs join
SQL
0 vote195 views1 answer
How to get first 10 records of a table in mysql
SQL
21 votes187 views1 answer
Cheatsheet for sql
SQL
0 vote195 views1 answer
Sqlalchemy one column of two has to be not null
SQL
4 votes194 views2 answers
How to insert ip address in mysql using php
SQL
0 vote183 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
11 votes193 views3 answers
Python sqlite3 create table if not exists
SQL