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 vote330 views1 answer
Mysql data from file
SQL
0 vote318 views1 answer
Mysql shell set time_zone
SQL
0 vote321 views1 answer
Sql server current time without date
SQL
-1 vote318 views1 answer
How to check table exists or not in postgresql
SQL
0 vote319 views1 answer
Connect postgresql using a connection string
SQL
0 vote350 views1 answer
Sql filter rows with condition
SQL
1 vote303 views4 answers
Fatal database postgres does not exist
SQL
0 vote334 views1 answer
Select row with latest date mysql
SQL
5 votes332 views3 answers
Oracle first day of last year
SQL
0 vote333 views1 answer
Sql insert from excel
SQL