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

12 votes153 views4 answers
Mysql version query
SQL
0 vote152 views1 answer
Move table to a different schema
SQL
3 votes184 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote149 views1 answer
Oracle sql developer closed connection
SQL
0 vote158 views1 answer
Soql user profile
SQL
1 vote215 views1 answer
Oracle transaction rollback not working
SQL
0 vote139 views1 answer
Oracle create package body
SQL
3 votes162 views2 answers
See mysql users ubuntu
SQL
4 votes148 views2 answers
Sql table
SQL
10 votes162 views2 answers
Mysql remove only_full_group_by permanently
SQL