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 votes228 views1 answer
Oracle session date format
SQL
5 votes229 views1 answer
Oracle list days between two dates
SQL
0 vote226 views2 answers
Create fulltext index mysql
SQL
0 vote233 views1 answer
How to declare variable date in mysql
SQL
1 vote223 views1 answer
Mysql get character set
SQL
1 vote239 views1 answer
Altrer name column postgres
SQL
1 vote232 views1 answer
Backup mysql data only
SQL
0 vote214 views1 answer
Create domain sql
SQL
0 vote237 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote241 views1 answer
Sqlalchemy one column of two has to be not null
SQL