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 vote398 views1 answer
Querry mysql by 2 columns
SQL
5 votes340 views2 answers
Oracle tables with column name
SQL
0 vote349 views1 answer
Reading from right to left from string find first special characters in sql
SQL
12 votes401 views5 answers
Rename table in mysql
SQL
1 vote367 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote375 views2 answers
Dumping sql table
SQL
6 votes386 views2 answers
Difference between join vs union
SQL
0 vote350 views1 answer
Sql fetch next 10 rows pdo
SQL
11 votes366 views2 answers
Insert date sql
SQL
3 votes367 views1 answer
Force using index oracle
SQL