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 votes205 views2 answers
Sqlserver docker
SQL
1 vote214 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote225 views1 answer
Sql put two columns into one
SQL
1 vote370 views1 answer
Import sql file from laravel
SQL
0 vote198 views1 answer
T-sql conditional order by multiple columns
SQL
5 votes193 views1 answer
Ora-00054 find lock
SQL
0 vote264 views1 answer
Sql commands in android
SQL
4 votes258 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote216 views1 answer
Postgresql escape single quote
SQL
1 vote207 views1 answer
Too many connections mysql
SQL