Subscribe
Discuss
What's new
What is it
New Snippet
Recent Snippets
My Snippets
Web Code
SearchLanguage: SQL
Script to create commands to remove all foreign keys in a database
SELECT 'ALTER TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME + '] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']' FROM information_schema.table_constraints WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'
by
Tags:
Report Abuse
brought to you by:
If you find this site useful and use it frequently please consider making a donation to support this free service.
