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 votes350 views1 answer
Sql count having
SQL
17 votes368 views4 answers
Postgres list users
SQL
0 vote373 views1 answer
Adding primery key constraint to a column
SQL
10 votes347 views6 answers
Between sql
SQL
17 votes375 views6 answers
What is cursor in sql server with example
SQL
0 vote332 views1 answer
Sql select non unique
SQL
4 votes348 views3 answers
NOT NULL SQL
SQL
0 vote345 views1 answer
How to check xampp mysql password
SQL
0 vote338 views1 answer
Sql query to select records entered in last 24 hours
SQL
13 votes335 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL