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

1 vote210 views1 answer
SQL Integer devision
SQL
0 vote226 views1 answer
Mysql get nth highest
SQL
3 votes211 views4 answers
Ubuntu stop mysql
SQL
0 vote212 views1 answer
Sql: extract day text from datetime value
SQL
0 vote198 views2 answers
Postgres show current role
SQL
0 vote208 views1 answer
Postgres list all stored procedures query
SQL
0 vote223 views1 answer
SQL check if record exist
SQL
2 votes211 views2 answers
Oracle create table if not exists
SQL
2 votes195 views2 answers
Get all columns from table sql
SQL
0 vote200 views1 answer
Mysql show create db
SQL