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

3 votes155 views1 answer
Oracle limit user tablespace
SQL
0 vote190 views1 answer
Mysql show foreign keys column
SQL
1 vote104 views2 answers
Get date from datetime postgresql
SQL
1 vote144 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote142 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote151 views1 answer
Import Data in MySQL without using any other software
SQL
1 vote135 views1 answer
Mysql get latest duplicate rows
SQL
2 votes134 views1 answer
Sql update from different table
SQL
2 votes145 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote142 views1 answer
Sql missing values
SQL