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 vote233 views2 answers
Mysql: command not found
SQL
7 votes263 views2 answers
Mysql check db size
SQL
2 votes237 views2 answers
Oracle no data found error code
SQL
0 vote244 views1 answer
Sql datediff db2
SQL
0 vote230 views1 answer
Sql get month and year from date
SQL
1 vote244 views1 answer
Sql first
SQL
5 votes236 views2 answers
Sql create tabel with primary key auto_increment code
SQL
1 vote235 views1 answer
Apex select list ORA-20999
SQL
4 votes245 views2 answers
Oracle unlock user
SQL
0 vote239 views1 answer
Declare date variable sql
SQL