34,593
社区成员
发帖
与我相关
我的任务
分享
IF SCHEMA_ID('aaa') IS NULL
BEGIN
EXEC('CREATE SCHEMA [aaa] AUTHORIZATION [dbo]')
END
SELECT SCHEMA_ID('aaa')
if not exists(select 1 from sys.schemas where name='ms_lc')
exec('create schema [ms_lc] authorization [dbo]')
if exists(select 1 from sys.schemas where name='ms_lc')
drop schema [ms_lc]
go
create schema [ms_lc] authorization [dbo]