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 vote296 views1 answer
Apex ORA-20999
SQL
0 vote271 views1 answer
Like and not like together in sql
SQL
0 vote324 views1 answer
How to change mysql root password in windows 10
SQL
14 votes294 views1 answer
Sql value of string
SQL
0 vote287 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote273 views2 answers
How to see table associated with a schema in sql
SQL
0 vote290 views1 answer
Allow external access to mysql
SQL
0 vote302 views1 answer
Postrgres trunc
SQL
4 votes309 views5 answers
Get last query in codeigniter 4
SQL
1 vote292 views1 answer
Oracle turn off constraint
SQL