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 votes264 views1 answer
To date oracle with time
SQL
0 vote267 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote272 views1 answer
Pl sql constraint user function
SQL
0 vote458 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote262 views1 answer
Time in sql server
SQL
4 votes299 views1 answer
Postgresql list sequences
SQL
0 vote258 views1 answer
What does the -p flag do in mysql cli
SQL
3 votes278 views2 answers
Df to sql pandas sql achemy
SQL
22 votes271 views3 answers
Join three tables sql
SQL
0 vote272 views1 answer
How to create an SQL save method in ruby
SQL