I know this is a very simple task for a lot of people. But I had been looking for the easiest way to do this task for long. Youtube helped me to finding the easiest way to this task. So I am not gonna write a lot of text. I will just paste the you [...]
Archive for April, 2011
13 Apr
Delete all foreign key refernce for a Table using one T-SQL statement
I was looking for a t-sql query which will delete all foreign key reference for a Table. My table has referenced by 13 different table. I needed to Truncate the Table named Table_A. Suppose I was Truncating Table_A, which was referenced by 13 table. So I ran the T-SQL query first to list all reference [...]
