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

1 vote195 views1 answer
Blob datatype in mysql
SQL
5 votes236 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote204 views2 answers
Unique key
SQL
1 vote268 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
2 votes311 views1 answer
Tsql copy table
SQL
0 vote220 views1 answer
SQL Query to delete all the tables in a database
SQL
1 vote265 views1 answer
Connect to mysql database ubuntu
SQL
0 vote195 views3 answers
Magento 2 order delete from db
SQL
0 vote204 views1 answer
Query builder doctrien return sql
SQL
0 vote206 views2 answers
Insert data mysql with cmd
SQL