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

15 votes138 views7 answers
MYSQL
SQL
1 vote166 views2 answers
Sql where is not number
SQL
0 vote160 views1 answer
Dataframe lambda elif
SQL
2 votes144 views1 answer
While loop sql
SQL
2 votes95 views1 answer
Sql select in list
SQL
11 votes160 views2 answers
How to import mysql database command line
SQL
1 vote141 views1 answer
Mysql show table character set
SQL
0 vote137 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote147 views1 answer
Oracle right characters
SQL
2 votes158 views1 answer
Drop all foreign key constraints mysql
SQL