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