I’ve come across a few occasions where we need to find out permissions for our username on a given table in the database. An easy way of doing this is by means of using the system stored procedure sp_table_privileges. The…
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…