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 vote160 views1 answer
Postgresql delete cascade
SQL
0 vote154 views1 answer
Number(10 2) in sql means
SQL
0 vote225 views1 answer
Linux upload database to mysql
SQL
1 vote171 views2 answers
Setval max id postgresql sequence
SQL
0 vote166 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote162 views1 answer
Create database like
SQL
2 votes144 views1 answer
Drop table purge
SQL
0 vote157 views1 answer
Sql reverse order of results
SQL
0 vote191 views5 answers
How to make trigger in phpmyadmin
SQL
3 votes145 views1 answer
Search for column name in psql
SQL