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 vote127 views1 answer
Wordpress change url phpmyadmin
SQL
1 vote114 views1 answer
Display total number of tables in mysql
SQL
4 votes132 views2 answers
Oracle unlock account
SQL
2 votes112 views1 answer
Mysql clear screen
SQL
0 vote110 views1 answer
Sql comparison operators
SQL
0 vote143 views1 answer
Create table using the clause with as
SQL
0 vote112 views1 answer
Sqlite referential integrity
SQL
0 vote126 views1 answer
Postgresql print sessions using the database
SQL
1 vote77 views2 answers
Last working day in week date function in sql
SQL
4 votes107 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL