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 vote290 views1 answer
Postgresql stored procedure update table values
SQL
1 vote286 views2 answers
Oracle create synonym
SQL
0 vote259 views1 answer
Sqlite select split string
SQL
0 vote273 views1 answer
Oracle query archive mode
SQL
0 vote307 views1 answer
Wordpress make wp user in db
SQL
0 vote266 views1 answer
Sql values not in another table
SQL
6 votes248 views2 answers
Return columns from table sql
SQL
1 vote264 views1 answer
Show per page table in xampp
SQL
0 vote250 views1 answer
Oracle select invalid views
SQL
0 vote264 views1 answer
Oracle list subpartitions
SQL