C#检测SqlServer中某张表是否存在

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

-- ============================================= -- Author:      <杨俊明(菩提下的杨过 http://yjmyzz.cnblogs.com/)> -- Create date: <2010-5-17> -- Description: <检查指定表是否存在> -- ============================================= Create PROCEDURE up_TableExists     @tableName nvarchar(50) AS BEGIN     declare @sql nvarchar(max);     set @sql = 'select COUNT(*) from sysobjects where id=object_id(N''' + @tableName + ''') and OBJECTPROPERTY(id,N''IsUserTable'')=1';     print @sql     exec(@sql) END GO

c#调用这个存储过程，返回1则存在，返回0则表不存在