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

4 votes137 views4 answers
Oracle tablespace tables list
SQL
0 vote186 views1 answer
Contraint default SQL
SQL
1 vote148 views1 answer
Sql drop schema
SQL
1 vote143 views1 answer
Postgres start database on linux
SQL
2 votes154 views3 answers
Sql interview query questions
SQL
0 vote145 views1 answer
Oracle calculate statistics on partition
SQL
0 vote136 views1 answer
SqlFunction does not exist
SQL
2 votes188 views5 answers
Install postgresql 10 centos 7
SQL
3 votes160 views1 answer
Set default today mysql
SQL
0 vote129 views1 answer
Nth max in my sql
SQL