Alter table rename constraint

In SQL, we sometimes need to rename the constraints of a table.

Rename constraint postgres

Rename constraint postgres

Mysql rename constraint

Sql server rename default constraint

Drop constraint

Add constraint in sql

The whole process for doing the same is demonstrated below. For this article, we will be using the Microsoft SQL Server as our database.

Step 1: Create a Database. For this use the below command to create a database named GeeksForGeeks.

Query:

CREATE DATABASE GeeksForGeeks

Output:

Step 2: Use the GeeksForGeeks database.

For this use the below command.

Query:

USE GeeksForGeeks

Output:

Step 3: Create a table INFO inside the database GeeksForGeeks. This table has 3 columns namely S_NAME, ROLL, and BRANCH containing the name, roll number, and branch of various students studying in an engineering college.

Query:

CREATE TABLE INFO( S_NAME VARCHAR(20), ROLL INT, BRANCH VARCHAR(5));

Output:

Step 4: Add a user-defined CHECK CONSTRAINT named BRANCH_CHECK constraint to the INFO table.

This constraint checks that the branch of a student entered in the database is among the 5 branches taught in the engineering college namely Computer Science and E

how to drop constraint without constraint name in sql

how to add primary key constraint name in sql