Quite often there are cases where we will have set of tables linked by means of foreign key relationships. Deleting from one among such tables can be a real pain especially when it having lots of direct and indirect dependencies…
sp_fkeys v/s sp_foreignkeys
sp_fkeys and sp_foreignkeys are two system procedures available in SQL Server giving information about foreignkeys. Then what exactly is difference between them? For this lets see the syntax of both. sp_fkeys ————— sp_fkeys @pktable_name, @pktable_owner, @pktable_qualifier, @fktable_name, @fktable_owner, @fktable_qualifier If…