to the reply from igor to my post earlier. I didnt say delete the table. I was talking about removing the referenced data e.g
TableAID int PRIMARY Key IDENTITY(1,1),
TableBID INT PRIMARY Key,
TableAID INT FOREIGN KEY CONSTRAINT,
TableCID INT FOREIGN KEY CONSTRAINT
TableCID int PRIMARY Key IDENTITY(1,1),
In the past I've removed linked data that is referenced within TableB and removed them from TableB using deletes before then removing them from TableA or in my case there was more than one place with referenced foreign key data removing it before deleting from the main table did the job. especially as I was using Ids using Identity e.g ID = 1, and referencing Table B using this as a foreignKey.
I was expecting kapils example to be the same as above or similar in which case my advise was to also remove data from any table referencing data as best practice.
of course if data is not being referenced then fine go ahead use the delete and remove data from TableA. I've never had to remove constraints, seems pointless then having to recreate them.
If I misunderstood no worries. Looks like kapils resolved.