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

2 votes134 views2 answers
Mysql date range
SQL
0 vote98 views1 answer
Mysql jdbc timezone
SQL
3 votes106 views1 answer
How to uninstall microsoft sql server
SQL
0 vote109 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote108 views2 answers
How to count codition
SQL
3 votes105 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote110 views1 answer
Alter table engine mysql
SQL
0 vote103 views1 answer
Consulta alias con inner join
SQL
0 vote59 views2 answers
Avg() sql
SQL
1 vote99 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL