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 vote223 views2 answers
Sql trigger difference between for and after
SQL
0 vote198 views1 answer
Opensuse stop MySQL
SQL
3 votes211 views1 answer
Mysql load sql from file
SQL
22 votes205 views3 answers
Join three tables sql
SQL
2 votes205 views1 answer
Sqlite show table indexes
SQL
0 vote219 views1 answer
Mysql query with sql to get the next row
SQL
-2 votes214 views2 answers
Sqlserver docker
SQL
0 vote211 views1 answer
Select insert new table sql server
SQL
3 votes201 views1 answer
Select without null values sql
SQL
0 vote255 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL