record not delete if id use another table in sql query

Question

i friend how to prevents delete operation if one table id use another table like i have one table city and there value ajmer, jaiupr, etc and another table district and in this table use city id and when i will delete city then if city id use in district table that not delete else delete

Nirav Daraniya · Answer

Hello Devendra, IF you use 'city_id' as primary key in "City" table and then use it('city_id') as foreign key in "District" table ,then it will work well, this concept will prevent the delete action in "City" table value If its use in "District" table. -- Nirav Daraniya

Vinay Singh · Answer

Hi In if you are using SP on that case in your query just . add a validation query if the passed city id exists in the District then dont delete and return a parameter 0 or 1 . 1-deleted 0-not deleted Suppose u r using @cityId as parameter in SP Eg: If exists(select * from District where CityId=@cityId) Begin select 0 as DelteStatus End Else Begin delete from District where CityId=@cityId select 1 as DelteStatus End Now in your code use the above SP to validate the delete status

Ranjit Powar · Answer

use primary key and foreign key.

record not delete if id use another table in sql query

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)