Hi guys, Welcome to the Advanced Video Search Engine, and you are watching ADD and DROP a Constraint using ALTER TABLE command in SQL || Lesson 42 || DBMS || Learning Monkey |. That video is uploaded by Learning Monkey at 2021-10-25T00:30:06-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [1ecXPI9V2Gk]
| Name | ADD and DROP a Constraint using ALTER TABLE command in SQL || Lesson 42 || DBMS || Learning Monkey | |
| Video Uploader | Video From Learning Monkey |
| Upload Date | This Video Uploaded At 25-10-2021 07:30:06 |
| Video Discription | ADD and DROP a Constraint using ALTER TABLE command in SQL In this class, we will understand ADD and DROP a Constraint using ALTER TABLE command in SQL. We have already discussed the concepts of ADD, DROP, and MODIFY columns of a table. ADD and DROP a Constraint using ALTER TABLE command in SQL This class will understand how to ADD and DROP a Constraint using ALTER TABLE command in SQL. To understand, we will consider the user’s table as shown below. The above is what we have considered in our previous class. We haven’t created a primary key for the user’s table. We will now alter the table by adding the id column as the primary key. ADD Constraint ALTER TABLE users ADD CONSTRAINT pk_users PRIMARY KEY (id); In the above command, ADD CONSTRAINT is the keyword used to add a constraint. Whenever we add a constraint, we have to give the name of the ‘constraint.’ In our case, we have given the name pk_users. These names are significant because they are used in the future to change the constraints. The new constraint has been added. To check whether the constraint has been altered, let us insert the row as shown below. DROP Constraint ALTER TABLE users DROP CONSTRAINT pk_users; The DROP CONSTRAINT is the keyword used to drop the constraint. In the above command, the constraint name has been used. By executing the above command, the primary key constraint will get dropped. To check whether the constraint has been dropped or not, we will insert the row as shown below. Even though the id value exists in the id column, the row will get inserted. #learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements Link for playlists: https://www.youtube.com/channel/UCl8x4Pn9Mnh_C1fue-Yndig/playlists Link for our website: https://learningmonkey.in Follow us on Facebook @ https://www.facebook.com/learningmonkey Follow us on Instagram @ https://www.instagram.com/learningmonkey1/ Follow us on Twitter @ https://twitter.com/_learningmonkey Mail us @ learningmonkey01@gmail.com 1ecXPI9V2Gk |
| Category | Education |
| Tags | ADD and DROP a Constraint using ALTER TABLE command in SQL | add constraint primary key | drop constraint oracle | drop constraint sql server | alter table in sql | alter table command in sql | sql | sql commands | sql commands tutorial for beginners | dbms | dbms for placements | dbms for placement preparation | learning monkey | learning monkey dbms | gate cse | gate cse dbms | gate cse full course | gate cse free lectures | gate cse free online coaching | gate cse free course | gate cs syllabus |
