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 vote104 views1 answer
Kill thread
SQL
-1 vote120 views2 answers
Create temporary table sql
SQL
1 vote151 views2 answers
Sql split string by space
SQL
1 vote126 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote98 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote112 views1 answer
Select last 2 characters sql
SQL
31 votes105 views1 answer
Postgresql add column with constraint
SQL
0 vote64 views1 answer
Ms sql unique
SQL
0 vote56 views1 answer
Oracle sql developer script output limit
SQL
7 votes104 views1 answer
Sql server convert string to date
SQL