4rfc 发表于 2014-1-16 08:53:43

Sql server中判断表是否存在

IF EXISTS(SELECT* FROM dbo.SysObjects WHERE ID = object_id(N'') AND OBJECTPROPERTY(ID, 'IsTable') = 1)
PRINT 'Exist'
ELSE
PRINT 'Not Exist'

页: [1]
查看完整版本: Sql server中判断表是否存在