Microsoft SQL Server 旧版本创建表和序列时判断存在就删除可重复执行sql

职业退堂鼓选手

已于 2024-01-15 15:33:34 修改

阅读量439

点赞数 12

文章标签：数据库 sql mssql

于 2024-01-15 15:24:27 首次发布

本文链接：https://blog.csdn.net/weixin_39412471/article/details/135602336

版权

创建表的语句

IF EXISTS
(
SELECT * 
FROM sys.tables 
WHERE SCHEMA_NAME(schema_id) ='dbo'
AND name ='MyTable0'
)  

   DROP TABLE [dbo].[MyTable0];  

GO

 create TABLE [dbo].[MyTable0]{
 ID BIGINT NOT NULL PRIMARY KEY;
};

创建序列的语句

IF EXISTS
(
SELECT * 
FROM sys.sequences
WHERE SCHEMA_NAME(schema_id) ='dbo'
AND name = 'Sequence_Name''
)

     drop SEQUENCE  [dbo].[Sequence_Name]

GO

 CREATE SEQUENCE [dbo].[Sequence_Name] 
    AS [bigint]
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    MAXVALUE 9223372036854775807
    CACHE  3