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

0 vote158 views1 answer
Hibernate with springboot mysql
SQL
0 vote166 views1 answer
Min and max salary and name in sql
SQL
0 vote184 views1 answer
Dataframe lambda elif
SQL
1 vote168 views1 answer
Oracle select first result
SQL
7 votes157 views1 answer
Forge server hosting
SQL
6 votes171 views1 answer
Phpmyadmin password root
SQL
9 votes175 views3 answers
Oracle undo usage by session
SQL
3 votes181 views1 answer
Define REGEXP?
SQL
3 votes157 views1 answer
Oracle get trigger ddl
SQL
1 vote170 views2 answers
Restart identity cascade
SQL