tag:blogger.com,1999:blog-16771259.post7646021623270554855..comments2024-03-07T03:02:45.934-08:00Comments on SQL Server Code,Tips and Tricks, Performance Tuning: Dropping all objects in a schemaUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-16771259.post-27578076062907489172024-03-07T02:46:42.206-08:002024-03-07T02:46:42.206-08:00sequences
SELECT 'DROP SEQUENCE ' + QU...sequences<br /><br /> SELECT 'DROP SEQUENCE ' + QUOTENAME(SCHEMA_NAME(schema_id))<br /> +'.'+ QUOTENAME(name)<br /> from sys.sequences<br /> WHERE schema_id = SCHEMA_ID(@SchemaName)Rodrigo Lopeshttps://www.blogger.com/profile/12243807064384097962noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-77776865882207804662020-10-09T03:22:05.981-07:002020-10-09T03:22:05.981-07:00Very helpful... You also missed synonyms though :)...Very helpful... You also missed synonyms though :)<br /><br />SELECT 'DROP SYNONYM ' +QUOTENAME(SCHEMA_NAME(schema_id))+'.'+QUOTENAME(name)<br />FROM sys.synonyms<br />WHERE schema_id = SCHEMA_ID(@SchemaName)Jim Burnellhttps://www.blogger.com/profile/04363608246460438269noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-27020545540207760032017-10-05T12:58:15.613-07:002017-10-05T12:58:15.613-07:00Javier... thanksJavier... thanksDenishttps://www.blogger.com/profile/13745938552201273794noreply@blogger.comtag:blogger.com,1999:blog-16771259.post-73368990016412684002017-10-05T12:36:16.411-07:002017-10-05T12:36:16.411-07:00Thanks for sharing, you may want to consider addin...Thanks for sharing, you may want to consider adding a statement for deleting user defined types:<br /><br /> SELECT 'DROP TYPE ' +QUOTENAME(SCHEMA_NAME(schema_id))+'.'+QUOTENAME(name) <br /> FROM sys.types<br /> WHERE schema_id = SCHEMA_ID(@SchemaName)<br /><br />I needed it myself.Anonymoushttps://www.blogger.com/profile/13163681811000477724noreply@blogger.com