-- Drop Views, Procedures and Functions, checking for dependencies and dropping dependencies first SELECT @ObjName = (SELECT TOP 1 '[' + s.name + '].[' + o.name + ']' FROM sys.objects o INNER JOIN sys ...
Removes a partition scheme from the current database. Partition schemes are created by using CREATE PARTITION SCHEME and modified by using ALTER PARTITION SCHEME ...