Advanced Search

Return to Snippet

Revision: 62344
at February 17, 2013 23:58 by fixpq
Initial Code 
SELECT 
    'ALTER TABLE ' + OBJECT_NAME(parent_object_id) + 
    ' DROP CONSTRAINT ' + name
FROM sys.foreign_keys

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
Initial URL 









Initial Description





It removes relations before deleting tables.









Initial Title





Delete all tables from SQL









Initial Tags





sql









Initial Language





SQL