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 vote123 views1 answer
Mysql backup certain tables workbench
SQL
13 votes117 views2 answers
Get tables in database sql
SQL
-1 vote120 views1 answer
Get id from just inserted row mysql server python
SQL
5 votes114 views1 answer
Oracle scan source ddl
SQL
20 votes123 views3 answers
Update values in select statement sql
SQL
0 vote110 views1 answer
Oracle for loop on list
SQL
0 vote109 views1 answer
Mysql cdn link
SQL
0 vote133 views1 answer
Limit in access query
SQL
1 vote119 views1 answer
Where not in array sql
SQL
0 vote124 views1 answer
Postgresql function ROUND
SQL