Cascading Referential Integrity Constraints in SQL Server through Query
Cascading Referential Integrity Constraints in SQL Server through Query.
|No Action,Set Null,Set default,Cascade|.
--Cascading Referential Integrity Constraints in SQL Server through Query
--The Cascading Referential Integrity Constraints in SQL Server that tell
--SQL Server to perform certain actions whenever a user attempts to delete or update a primary key
--NO ACTION
--This is the default action that SQL Server performs. This specifies that if an update or deletes statement affects rows in foreign key tables,
--then the action will be denied and rolled back. An error message will be raised
create Table Country
(
CountryId int primary key,
Name varchar(100)
)
Insert into Country values(1,'India')
Insert into Country values(2,'UK')
create Table Customer
(
CustomerId int primary key,
Name varchar(100),
CountryId int foreign key references Country(CountryId)
)
insert into Customer values(1,'Arun',1)
insert into Customer values(2,'Biju',null)
insert into Customer values(3,'Peter',2)
insert into Customer values(4,'Meera',1)
select * from Country
select * from Customer
--delete from Country where CountryId =1
--SET NULL
--when the primary key record is deleted or updated in the Primary key table that time foreign key column will be set to null
--we marked that column as allow null
--drop table Country
--drop table Customer
create Table Country
(
CountryId int primary key,
Name varchar(100)
)
Insert into Country values(1,'India')
Insert into Country values(2,'UK')
create Table Customer
(
CustomerId int primary key,
Name varchar(100),
CountryId int foreign key references Country(CountryId)
on delete set null
)
insert into Customer values(1,'Arun',1)
insert into Customer values(2,'Biju',null)
insert into Customer values(3,'Peter',2)
insert into Customer values(4,'Meera',1)
select * from Country
select * from Customer
--delete from Country where CountryId =1
--CASCADE
--when the primary key record is deleted or updated in the Primary key table that time foreign key column will also be deleted or updated
--drop table Country
--drop table Customer
create Table Country
(
CountryId int primary key,
Name varchar(100)
)
Insert into Country values(1,'India')
Insert into Country values(2,'UK')
create Table Customer
(
CustomerId int primary key,
Name varchar(100),
CountryId int foreign key references Country(CountryId)
on delete cascade
)
insert into Customer values(1,'Arun',1)
insert into Customer values(2,'Biju',null)
insert into Customer values(3,'Peter',2)
insert into Customer values(4,'Meera',1)
select * from Country
select * from Customer
--delete from Country where CountryId =1
--SET DEFAULT
--If a delete or update statement affects rows in a foreign key table, then -all rows containing those foreign keys are set to the default value.
create Table Customer
(
CustomerId int primary key,
Name varchar(100),
CountryId int default 2 foreign key references Country(CountryId)
on delete set default
)
Sql Query for jobs
# / @sqlqueryforjobs
Playlists:
• SQL Query Interview Questions
• Stored Procedure in sql
• Sql Basics Through Query
• User Defined Functions in sql
• Build in functions in sql
• Views in sql
Cte Links:
• CTE in sql.| Common Table Expression|
• CTE using multiple tables/multiple CT...
• How to insert,update,delete data usin...
• Recursive CTE in sql.| Recursive Comm...
Stored procedure Links:
• How to create,alter,drop a stored pro...
• How to create a stored procedure with...
• Optional Parameter Stored Procedure i...
• How to Encrypt stored procedure in S...
• Return value of stored procedure in S...
• stored procedure summary in sql.
• How to use User defined Table type in...
• How to use Temp Tables in Stored Proc...
User Defined Functions Link:
• User Defined Scalar Functions in sq...
• Inline table valued function in sql |...
• Multi-Statement Table Valued Function...
• How to insert,update,delete datas to ...
• How to use User defined Table type in...
• How to set SchemaBinding in User defi...
Sql Query Interview Questions Link:
• Write a query to find the stock of ea...
• Write a query to fetch the employees ...
• Write a Query to Get Largest Sold Pr...
• Write a Query to find Diffrence of ea...
• How to delete duplicate records in sq...
• Write a query to merge source table d...
• Write a query to display two column v...
• Write a query to display converts the...
• Write a query to generate cricket tou...
• Write a Procedure to Get display Tabl...
#sql #sqlserver #sqlab #sqlinjection #mssql #sqldeveloper #sqlsaturday
#sql #programming #database #sqlserver #coding #developer #programmer #software #datascience #code #computerscience #data #dataanalytics
#technology #computer #development #bigdata #backend #coder #codinglife #microsoft #sqldatabase #softwaredeveloper #informationtechnology #programminglife #softwaredevelopment #programmerslife #sqlforbeginners #sqltraining #sqlinterviewquestions #mssqlserver
Watch video Cascading Referential Integrity Constraints in SQL Server through Query online without registration, duration hours minute second in high quality. This video was added by user Sql Query for jobs 26 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 38 once and liked it 1 people.