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 vote336 views1 answer
How to declare variable date in mysql
SQL
0 vote327 views2 answers
Reseed sql identity
SQL
0 vote447 views1 answer
Postgresql powershell query
SQL
0 vote328 views1 answer
Sql get number of days between two dates
SQL
0 vote327 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote320 views1 answer
Mysql table variables
SQL
0 vote335 views1 answer
Create boolean column in MySQL with false as default value?
SQL
2 votes323 views1 answer
Oracle drop sequence if exists
SQL
1 vote313 views1 answer
How to truncate a table in databse
SQL
14 votes369 views5 answers
Set password for postgres user ubuntu
SQL