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

17 votes134 views6 answers
Change column name in sql
SQL
2 votes130 views3 answers
How to check current user in mySQL
SQL
0 vote126 views1 answer
Restore backupfile discourse
SQL
3 votes121 views2 answers
Laravel tosql with bindings
SQL
0 vote144 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote154 views2 answers
Mysql add days to date
SQL
6 votes123 views6 answers
Count mysql
SQL
1 vote130 views1 answer
Postgres get timestamp
SQL
0 vote190 views1 answer
How to show current database in mysql
SQL
0 vote141 views2 answers
Faster mysql imports
SQL