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 vote122 views2 answers
Start mysql server using docker
SQL
-1 vote141 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote129 views2 answers
Sql use not in
SQL
2 votes140 views3 answers
How do I add a user to a postgres database? cli
SQL
1 vote138 views1 answer
Vagrant mysql downgrade version
SQL
1 vote136 views1 answer
Sql server today minus n
SQL
0 vote121 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote112 views1 answer
Frename oracle
SQL
1 vote132 views1 answer
Get create table query existing table mysql
SQL
4 votes117 views1 answer
Check database name postgresql
SQL