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 votes211 views6 answers
Sql insert into
SQL
0 vote194 views1 answer
Sql show all users
SQL
1 vote206 views1 answer
Mysql not supported auth mode
SQL
23 votes200 views1 answer
How remove column in mysql
SQL
0 vote196 views1 answer
Postgresql create query
SQL
0 vote188 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote200 views1 answer
Java nosql sort
SQL
47 votes291 views6 answers
Add column mysql
SQL
7 votes211 views2 answers
Postgres concat
SQL
18 votes229 views6 answers
Laravel form validation
SQL