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

0 vote327 views1 answer
Oracle select partition
SQL
1 vote340 views1 answer
Pl sql create table from another table
SQL
1 vote299 views2 answers
Oracle replace
SQL
0 vote349 views1 answer
SQL Cut part string
SQL
2 votes339 views3 answers
Sql function
SQL
1 vote312 views1 answer
Mysql month name extract
SQL
1 vote350 views1 answer
Mysql view curren querys
SQL
11 votes344 views2 answers
Oracle saurce code
SQL
1 vote318 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote316 views1 answer
Check if database exists sql
SQL