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

5 votes143 views1 answer
Sysdate in oracle sql
SQL
0 vote169 views1 answer
Oracle date summer time
SQL
0 vote145 views1 answer
Sql server count all tables rows
SQL
0 vote147 views1 answer
Mysql count with two joins
SQL
1 vote147 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
4 votes92 views1 answer
Generate class from sql table c#
SQL
0 vote154 views1 answer
Get date ISO in psql
SQL
5 votes152 views2 answers
Sql constraint check value in list
SQL
-1 vote131 views3 answers
Mysql get age from date
SQL
6 votes172 views6 answers
Rename column postgres
SQL