判断是否是一个表

create proc istable
 @tablename varchar(20) out
as
 if objectproperty(object_id(@tablename),'ISTABLE') = 1
  print '是一个表'
 else
 if objectproperty(object_id(@tablename),'ISTABLE') = 0
  print '不是一个表'
 else
 if objectproperty(object_id(@tablename),'ISTABLE') is NULL
  print '无效的值'
GO