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

4 votes113 views2 answers
How to insert ip address in mysql using php
SQL
1 vote103 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote105 views5 answers
Linq cheat sheet
SQL
6 votes112 views1 answer
Postgresql get year
SQL
0 vote102 views1 answer
Show tables in cassandra cql
SQL
6 votes141 views2 answers
Subtr Oracle ?
SQL
0 vote102 views1 answer
Mysql wait_timeout
SQL
1 vote102 views2 answers
Select into temp table
SQL
0 vote100 views2 answers
Sql update top 100
SQL
0 vote106 views2 answers
Demmarrer un service mysql teminal cmd
SQL