SQL SERVER2008中的sys.objects表

数据库：SQL SERVER2008

SQL：（查找类型为用户表，对象名称为OrderMeetUpload，的表信息，这里的N是表明为 Unicode类型.可以支持不同语种的对象名）

select * from sys.objects
where type in (N'U')
and object_id = OBJECT_ID(N'[dbo].[OrderMeetUpload]'))

常常用于，创建对象（如：表）时，判断使用

 

SQL：

if not exists(
select * from sys.objects
where 
type in (N'U')
and object_id = OBJECT_ID(N'[dbo].[OrderMeetUpload]'))
begin
	CREATE TABLE [dbo].[OrderMeetUpload](
		[BindId] [int] IDENTITY(1,1) NOT NULL,
		[FilePath] [nvarchar](255) NOT NULL,
		[OptCode] [nvarchar](20),
		[OptName] [nvarchar](20),
		[OptDate] [smalldatetime],
		[OrderUuid] [nvarchar](255) not null,
		[FileName] [nvarchar](50) not null
	 CONSTRAINT [PK_OrderMeetUpload] PRIMARY KEY CLUSTERED 
	(
		[BindId] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
	) ON [PRIMARY]
end

 

文章参考：

SQL Server系统表sysobjects介绍与使用