C#檢測SqlServer中某張表是否存在

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

c#調用這個預存程序，返回1則存在，返回0則表不存在