How can I list all foreign keys referencing a given table in SQL Server? -


I need to extract a highly referenced table in the SQL Server database. How do I drop all the foreign keys Obstacles must be removed, how can I get the list?

(Answer to SQL is better than clicking in Management Studio's GUI.)

< P> Not sure why no one suggests, but I use sp_fkeys to query foreign keys for a given table:

  EXEC sp_fkeys 'Table Name'  

Comments