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
Post a Comment