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 vote234 views3 answers
Mysqli count down
SQL
0 vote190 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote191 views1 answer
Mysql sleep connections
SQL
8 votes251 views1 answer
Insert a select statement into a table
SQL
0 vote188 views1 answer
Hex string sql becomes int64
SQL
3 votes183 views1 answer
V$session not found in oracle
SQL
3 votes179 views1 answer
Insert into table from another table mysql
SQL
0 vote190 views1 answer
Date 3 months from today sql
SQL
0 vote206 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote176 views1 answer
Sql include rows with 0 values
SQL