判断SQL Server中是否存在某张表，删掉重新创建

最新推荐文章于 2024-04-26 09:11:45 发布

一抹上扬的微笑

最新推荐文章于 2024-04-26 09:11:45 发布

阅读量663

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_43783990/article/details/130854103

版权

判断SQL Server中是否存在某张表，删掉重新创建

if OBJECT_ID(N'Park_DockingUploadTable',N'U') is not null
begin 
    drop table Park_DockingUploadTable
end


CREATE TABLE [dbo].[Park_DockingUploadTable](
	[bussinessType] [nvarchar](50) NULL,
	[bussinessId] [uniqueidentifier] NOT NULL,
	[thirdPartyBussinessId] [nvarchar](100) NULL,
	[bussinessStatus] [nvarchar](50) NULL,
	[c_createtime] [datetime] NULL,
	[back_status] [int] NULL,
	[companyName] [nvarchar](50) NULL,
	[companyCode] [nvarchar](50) NULL,
	[back_msg] [nvarchar](max) NULL,
	[isdeleted] [int] NULL,
 CONSTRAINT [PK_Park_DockingUploadTable] PRIMARY KEY CLUSTERED 
(
	[bussinessId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Park_DockingUploadTable] ADD  CONSTRAINT [DF_Park_DockingUploadTable_c_createtime]  DEFAULT (getdate()) FOR [c_createtime]
GO

ALTER TABLE [dbo].[Park_DockingUploadTable] ADD  CONSTRAINT [DF_Park_DockingUploadTable_back_status]  DEFAULT ((0)) FOR [back_status]
GO

ALTER TABLE [dbo].[Park_DockingUploadTable] ADD  CONSTRAINT [DF_Park_DockingUploadTable_isdeleted]  DEFAULT ((0)) FOR [isdeleted]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上传业务类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'bussinessType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'bussinessId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第三方业务id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'thirdPartyBussinessId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务数据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'bussinessStatus'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'c_createtime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上传状态 0 上传成功 1 上传失败 2数据验证失败' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'back_status'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'companyName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'companyCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证信息' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'back_msg'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除 1 删除，0 正常' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable', @level2type=N'COLUMN',@level2name=N'isdeleted'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对接上传业务中间表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Park_DockingUploadTable'
GO