修改SQL Server 2005 数据库的执行环境很简单
复制IF OBJECT_ID(usp_InsertMyTable,修改行环P)>0 DROP PROCEDURE usp_InsertMyTable GO IF OBJECT_ID(TableOwnerSchema.MyTable,U)>0 DROP TABLE TableOwnerSchema. MyTable GO IF EXISTS (SELECT * FROM sys.schemas WHERE name = NTableOwnerSchema) DROP SCHEMA [TableOwnerSchema] IF EXISTS (SELECT * FROM sys.database_principals WHERE name = NBaseUser) DROP USER BaseUser IF EXISTS (SELECT * FROM sys.server_principals WHERE name = NBaseUser) DROP LOGIN BaseUser IF EXISTS (SELECT * FROM sys.database_principals WHERE name = NTableOwner) DROP USER TableOwner IF EXISTS (SELECT * FROM sys.server_principals WHERE name = NTableOwner) DROP LOGIN TableOwner 1.2.3.4.5.6.7.8.9.
本文地址：http://www.bzuk.cn/html/180e6299757.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。