转自:http://scourings.blogbus.com/logs/32888215.html
OBJECT_ID
返回数据库对象标识号。
语法
OBJECT_ID ( 'object' )
例如:USE master
SELECT OBJECT_ID('pubs..authors')
查看pubs数据库里的authors表的object_id。
OBJECTPROPERTY
返回当前数据库中对象的有关信息。
语法
OBJECTPROPERTY ( id , property )
例如:OBJECTPROPERTY ( object_id('authors'),'ISTABLE') = 1
判断authors对象是否是一个表。
创建数据库
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Replies]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Replies]
GO
CREATE TABLE [dbo].[Replies] (
[ReplyID] [INT] NOT NULL ,
[Body] [Text] NULL ,
[CreateTime] [datetime] NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO