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

2 votes143 views1 answer
How to show the whole table in sql
SQL
0 vote139 views1 answer
Sql column contains special character
SQL
0 vote127 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
2 votes161 views1 answer
Insert from table tsql
SQL
0 vote125 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
1 vote159 views1 answer
Is sql fast
SQL
0 vote127 views1 answer
How to use query in nosql
SQL
4 votes133 views1 answer
Phone number sql
SQL
1 vote133 views1 answer
Pl sql ptint
SQL
0 vote137 views1 answer
Oracle date winter time
SQL