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 vote382 views1 answer
Sql view where tables have same column name combine results
SQL
-1 vote386 views2 answers
Sql search all tables for attributes
SQL
0 vote361 views1 answer
Sql contains numeric characters
SQL
0 vote367 views1 answer
Mysql disable triggers
SQL
0 vote414 views1 answer
Python get backup of sql
SQL
0 vote338 views1 answer
C# check if mysql query modified rows
SQL
3 votes348 views2 answers
Sql paging query
SQL
0 vote366 views1 answer
Mysqli last row
SQL
7 votes371 views1 answer
Query postgres delete duplicates
SQL
0 vote352 views1 answer
Formatting code with SQL Developer
SQL