Cascading referential integrity constraint - Part 5
ฝัง
- เผยแพร่เมื่อ 2 ต.ค. 2024
- In this video, we will learn about Cascading referential integrity constraint
Text version of the video
csharp-video-tu...
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our TH-cam channel. Hope you can help.
/ @aarvikitchen5572
Slides
csharp-video-tu...
All SQL Server Text Articles
csharp-video-tu...
All SQL Server Slides
csharp-video-tu...
All Dot Net and SQL Server Tutorials in English
www.youtube.co...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic
uploaded 8 years back.. still, all ppl are watching and praising you sir, we can't find this type of excellent tutorial from anywhere. Thanks a lot.........
10 years ago.
11
@@BeingSam7 legend detected! 🤩
@@rayhanmahmud6579 - Thanks bro, but Venkat is legend here.
Sql command to perform the same action
ALTER TABLE tblPerson ADD CONSTRAINT FK_tblPerson_ID
Foreign Key(GenderID) REFERENCES tblGender(ID) ON DELETE CASCADE/SET NULL/SET DEFAULT
Thanks a lot Venkat , ur videos are really very helpful... this is the best tutorial on sql. Even beginner can become a master by learning through this
tutorial
THANK YOU SIR........................................Excellent Tutorial..
venkat sir i invested 15000 in a coaching for sql server but really belive me when i saw all of ur videos it seems that they didn't teach me anythng. ur videos are helping all IT students and espicly for those who dnt have money to join any coaching class. so thanku thanku thanku thanku sir for making this great tutorials.now i can say myslef i m a Sql MASTER :p
suresh rajput I agree with you Suresh .... After seeing these videos nobody needs any kind of coaching classes.
I just started and hoping to be a DBA, if you dont mind telling me..did you study only this (his videos )or did you use other resources and how did you do your studing? I could use your advice i want to be a master at it too :) thanks alot
I wasted time and money on UDEMY.. Udemy is no match in front of this Tutorial...best ever
This video is short, understandable and very useful. Great job kudvenkat! Keep going on in the same way :)
Self explained videos for learning.....Great job.
your way of explanation is cool and i liked it a lot
great teacher - crystal clear
thankyou so much .pple like u will save the world
Great video! Thank you so much for sharing!
PRANAM GURUDEVA
GURU SAKSHAT PRAMBRHMA
TASMAYE SHREE GURUVE NAMAH !
YOU'RE THE BEST
THANK YOU SO MUCH I HAVE MY FINALS IN 5 DAYS LOOOOL!!!
best tutorial for SQL learning..thank you sir
Great work! Even in 2023
Great videos!
How to use Cascade constraint using query
thank you!
Hi Venkat, really concepts is very, excellent but if I want to do applying referential integrity constraint by using Query how can I do, please provide with Query too. Thank you
In 2020 quarantine learning great content from this excellent Sir. Thank you
Very Good job. Thank you sir
Sir...if there is no female in tblperson table means that in genderid column there is not a '2' then will it be executed or shown error????
you didn't not show (setnull ,cascade )non graphical version????
i am unable to get set default ,cascade, options under insert and update no action is constant could u help me out
Thanks Venkat for producing such AWESOME subject matter!! You are da man!! By chance would you happen to have the power point notes for these videos?
Hey Namita, on the top left hand corner of SQL Server management studio, there should be a dropdownlist showing the name of the database. Can you please make sure you have selected the database, that contains your table. Hope this helps. Good Luck.
what if we set null to delete rule but the gender id table donot support null values ??
Thank you so much for ur videos
Could you please do a Playlist videos in SSRS, SSIS, SSAS, POWER BI.
Today I got job at age of 25. As a mech engg, I started learning software with your channel. After 4 months of learning from diff sources, I got job today. But your channel is foundation where you taught from basics which even a 10th class kid can understand. I dont know how I can repay my debt to you.
I am also from mech background pllanning to switch career to SQL and database. Inhave a doubt whether we should do any another video course apart from these for getting a jr SQL developer role. Also did you apply for SQL role or analyst role?
@@allenvarughese1433 Currently doing SQL role. These are enough with practice.
Hi Venkat ,Good Evening , I have one question, how many hours we have to learn and the duration time of this 150 videos, can please respond
Awesome videos and great instructing! Thanks, thanks and Thanks! God bless you!
YOU ARE THE GOD, I LOVE YOU AND EVERY TUTORIALS YOU'VE MADE, YOU SAVE MY LIFE. TANKS A MILLIONS
Cascading referential integrity constraint - Part 5 (Sir when I am trying to delete the from tblGender where ID =2...…not getting any error row get effected)
This is one of the best presentation I ever seen, Well done KUDOS!!!
Mr Venkat your one of the best instructors that I know easy to understand no accent .Please don't listen those haters for your work. Thank you SIR!
Since I joined IT industry..whatever situation like job change .skill upgrade first option and choice for me is Venkat sir ..now I have 9 years of exp..
Can this be done using a Query? If Yes, Syntax Please!
CREATE TABLE [Person](
[Id] [int] PRIMARY KEY,
[Name] [varchar](100) NOT NULL,
[Email] [varchar](100) NOT NULL,
[GenderID] [int] CONSTRAINT FK_Person_GenderID FOREIGN KEY REFERENCES dbo.Gender(Id)
ON DELETE CASCADE
ON UPDATE CASCADE
)
I am not a native English speaker, so first i was afraid of this video, because I did not understand even the title of it, but now everything is clear and easy to understand!
You are the Master of teachers, Venkat!
If it is Set to NULL and the FK column is NOT NULL then also it will convert and affect the row?
the best
Hi Venkat!Thanks so much for this tutorial.I found what I had been looking for.Could you help me out with the following situation:
1-Let's say here a user tries deleting one of the genders from .NET interface.
2-We want users to see a warning message something like "This might affect some records."
How do we warn a user before deleting a gender here?Is there anything like try &catch?
Thanks.
Super ! Slide notes are also very helpful!
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Hello venkat sir,
I have got some problems when I try to set referential integrity.
Suppose I have created two tables as below :
create table tblUsers
(
UserID int NOT NULL Primary Key,
Name int NOT NULL
)
create table tblRelationships
(
RelationshipID int NOT NULL Primary key,
RequestSenderID int NOT NULL,
RequestReceiverID int NOT NULL,
[Status] nvarchar(30) NOT NULL
)
contined in next comment.....
Hi Venkat, Your videos are really very helpful for SQL beginners. Thanks a lot for your time. I have a doubt that can I use Ms Access as a frontend to SQL Server?
People like you will destroy the world. MS Access is itself a database, sql server management studio is a tool.
Hi Venkat,
Would it be possible for you to add the SQL code related to the above material.Doing it through GUI is easy but one should know the code to do that.
Revisiting to refresh BASICS.
I enjoyed watching this video and recommend others.
Thanks for educating the community and appreciate your volunteership.
Thanks a bunch
thank you again for such a great tutorial and helping me to learn SQL which will help me to get through for my Data Analytics.
secondly I am not into Web developer. as you mentioned in ur email reply.
Regards
thank you..
this tutorial is really good.
why when i delete the record in tblGender where gender is Female,
the record in field GenderId in tblPerson doesnt got default as '3', even though i have made the default constraint for GenderId int tblPerson.
Hey Venkat ... You are doing a great Job for all beginners ... Long Live !!!!!
Nice Explanation sir..Can you upload videos based on unit testing
THANK YOU SIR
ALTER TABLE tblPerson ADD CONSTRAINT tblPerson_GenderID_FK
FOREIGN KEY(GenderId)
REFERENCES tblGender(ID)
ON DELETE CASCADE
ON UPDATE CASCADE
How can I add delete/cascade/null default values through queries for deleteing the referenced values
Awesome explanation.Good work.
Good evening sir... Sir i am facing the problem of, ms visual database tools, ie this backend version is not supported to design database diagram....
Kindly tell how to fix it.. Regards
Great man does great job. tens of thanks and respect. Thank you again
thanks sir.
Hi Venkat. Your videos are very informative. I am a beginner trying to learn SQL and your videos are helping me do that. Thanks for that. I have a question:
If the Delete rule is set as default and if we try to delete the third row i.e. 3 Unknown. What will happen
I hope you saw that it was the first test case he did and it came up with an error?
the syntax is not working for command line code NUT alter table (table_name) alter(column of interest) set default (default needed)
Hello sir. When I try to change the delete rule to 'Set Default' or 'Set NULL' I'm getting an error while saving. And when I try to delete the row, it doesn't change the foreign key of the TblPerson table and it remains the same. Please help!
Can you please share the error message you are getting.
excellent explanation.....
Hi sir please can you provide the option to download PPT slides
Sir... What will happen if the Delete Rule is set to "Set Default" but, there is no default constraint on the field?
I think it would be ignored and No Action command would be applied.
Great Job. Very Useful tutorials!
Hello Sir
I have added default constraint to GenderId as shown in video
When i am trying to execute this query "insert into tblPersons (Id,Name,Email) values (9,'do','do@dora.com')"
it is showing error as "The INSERT statement conflicted with the FOREIGN KEY constraint "tblPersons_GenderId_FK". The conflict occurred in database "test", table "dbo.tblGender", column 'Id'"
Kindly suggest where i went wrong
Sir when I am trying to delete the from tblGender where ID =2...…not getting any error row get effected.
What procedure should one use to implement both a default value and on delete set default because I keep getting an error when I try to run:
ALTER TABLE tbl_person ADD CONSTRAINT df_tbl_person_gender_id DEFAULT 3 FOR gender_id ON DELETE SET DEFAULT; ?
Thank you for your wonderful tutorial
what will happen if i directly declare foreign key or primary key without using constraint........can u explain me please
+munesh raj Just try and see what happens..
I had the same situation as Suresh I completed a IT degree which was when I se Kudvankats tutorials a rip off as they covered topics such as OOP, etc superficially. Thank you Vankat for these videos. I am working on Part 5 Cascading referential... and find this error when I choose Set Null...Cannot SET NULL referential action, because one or more referencing columns are not nullable. Anyone have an idea how to solve this?
Hi Venkat, I have a query here. What would be the result, if user is selecting Null or Default value for “Delete Rule” and the foreign key column is having Not Null constraint or Default constraint is not defined for it??
we can't find this type of excellent tutorial from anywhere. Thanks a lot.........
hi...i have applied a foreign key to tblPerson...... when i insert a invalid row it doesnt allow me to add ,but i in NOAction ,when i delete a gender id ,its get deleted.....why ?
Thank you For The Videos!
Also,I would like to ask about duplicate entries in my data base.
My program reports CPU % to my SQL database & I really have no care for it to list ?%
50 times.
Any help on this would be great thank you.
So basically , this tutorial describes what happens to the Foreign key coloumn when a Update or Delete is done in the Primary Key coloumn
- Unable to create relationship 'FK_tblRelationships_tblUsers1'.
Introducing FOREIGN KEY constraint 'FK_tblRelationships_tblUsers1' on table 'tblRelationships' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors.
Now I have added two foreign key constraints for relationships.requestSenderID ----Users.UserID and for relationships.requestReceiverID ---- Users.UserID.namely FK_tblRelationships_tblUsers and FK_tblRelationships_tblUsers1
Now I want to set cascade on delete for both the foreign key constraints but I am getting the following error :
continued in next comment.....
Hey venkat thank you so much for ur videos ...it's been a Big help. I am trying to add default constraint in tblperson n I used same syntax like you . but I am getting following error"can not find the object tblperson because it does not exist or you do not have pessimism ".
Can you please tell me solution for that.thx
Hello sir can you create a video for how to install and download SQL server management studio for 32bit os windowa7
How can we do this with a query?
Looks like you need to drop and re-create the constraint
Does anybody have all sample tables from the videos
Hi. The video is gr8. But you did not mention what will happen if we delete the gender row which is set as default value for Gender and cascading option set as Set Default??
when I tried to delete the default value using set default Cascading Referential integrity delete from tblgender15 where ID= 3 it got deleted ,what if someone try to delete the default value ?
當要刪除包含外來鍵資料時，
一般未設定不能刪除
有多種模式
1.設為null
2.設為預設值
3.將參考的資料刪除
Very good!
Am I right in thinking that if you set the constraint to "set default" and then you delete the default, the rows in the tblperson table that had the default value will be set to null?
A pleasure to watch and listen. Excellent stuff. I can't praise highly enough.
Hi - i wont be able to change the update rule and delete rule " No action" i dont get the drop down option ? when i try to set the default value if we delete tblgender id female data. help
Thank You Sir
Very Help full Video..Very Nice Sir
Respected sir,......your all videos..are very helpful us.....m gone..fan of yours now...amazing....videoo..keep it up sir....
thanks so much!Your explanation is just awaresome....
cannot delete / change rules to Cascade today
Hi Mr. Venkat It is really grateful of you making these tutorials, can you please make video tutorials on WPF and Power BI. Thank you.
In my Sql , Insert and update option arenot editable. what hsould i do?
thank you very much for these tutorials
keep it up buddy you are my real teacher.....!!!!!!
once again thankyou very much.....
How to perform these actions using script and not doing it manually
Can you please share open file practice
how to do cascading referential integrity constraint using query? It will be very useful if you provide the syntax for that as a reply in the comment box.
ALTER TABLE tblPerson ADD CONSTRAINT tblPerson_GenderID_FK
FOREIGN KEY(GenderId)
REFERENCES tblGender(ID)
ON DELETE CASCADE
ON UPDATE CASCADE
I greatly fairly happy and fresh about sql thank u my dear sql guru
I enjoyed watching this video. I recommend to watch if you want to learn database stuff. Thanks a lot
thank you very much for sharing your knowledge..
awesome videos, well explained everything. Sharing my sincere thanks!!