SQL server 利用存储过程怎么判断一个表是否存在

create procedure proName 
		@TableName  NVARCHAR(50)
as
begin
    if object_id(N'表名',N'U') is null --判断表是否存在
    print (0)
	else
	print (1)
create procedure proName 
		@TableName  NVARCHAR(50)
as
begin
select(
  select
  OBJECT_ID
  from sys.tables
  where name = @TableName
) ;
end
alter procedure A 
@table_name  NVARCHAR(50)
as
begin
Declare
@sql nvarchar(256)
select  @sql =	STUFF ((select object_id(N''+@table_name+'',N'U') FOR XML PATH('')), 1, 1, '')

    if  @sql <>0 --判断表是否存在
    print '表存在'
	else
	print '表不存在'
	end

posted on 2022-07-28 17:13  唯一的Dove  阅读(367)  评论(0)    收藏  举报

导航