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 vote127 views1 answer
Now() -1 mysql
SQL
18 votes166 views2 answers
Sql inner join
SQL
0 vote153 views1 answer
Metada in sql
SQL
9 votes167 views4 answers
Add primary key to existing table sql
SQL
2 votes179 views3 answers
Sql delete duplicate
SQL
1 vote163 views1 answer
Partition by sql server
SQL
0 vote170 views1 answer
Conda install pymysql "windows"
SQL
0 vote162 views1 answer
Object Information
SQL
1 vote140 views2 answers
Get date from datetime postgresql
SQL
0 vote173 views2 answers
Sql query in dax power bi
SQL