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

9 votes375 views2 answers
Nosql databases
SQL
31 votes352 views4 answers
Mysql grant execute
SQL
2 votes313 views1 answer
Convert series number to date in sql
SQL
1 vote327 views1 answer
Mysql random limit 1
SQL
0 vote320 views1 answer
Mysql group by derived column
SQL
2 votes350 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote321 views1 answer
Mysql money value
SQL
0 vote324 views1 answer
Psql check if value in array
SQL
0 vote350 views2 answers
Mysql on update current_timestamp
SQL
3 votes339 views2 answers
Sql asc
SQL