检查Sql Database中是否存在表 [英] Check if a table exist in Sql Database's

问题描述

如何从存储过程中检查SQL数据库中是否存在表？

解决方案

？

 创建  procedure  check_table_exists 
  @ aTableName   varchar （ 50 ）
  as  
  return （ select  count（ *）来自 sysobjects 其中  type  = < span class =code-string>'  U' 和 name =  @ aTableName ）
  go  

访问这里......





检查数据库中是否存在表或字段 [ ^ ]



或





http://sqlserver2000.databases.aspfaq.com/ how-do-i-determination-if-a-table-in-a-sql-server-database.html [ ^ ]

1。

 IF EXISTS（SELECT 1 
 FROM INFORMATION_SCHEMA.TABLES 
 WHERE TABLE_TYPE ='BASE TABLE'
 AND TABLE_NAME ='mytablename'）
 SELECT 1 AS res ELSE SELECT 0 AS res; 

2.

 IF OBJECT_ID（N'。

how to Check if a table exists in the SQL Databases ?

解决方案

from a stored procedure?

create procedure check_table_exists
@aTableName varchar(50)
as
return (select count(*) from sysobjects where type = 'U' and name = @aTableName)
go

visit here...


Check if a table or field exists in a database[^]

or


http://sqlserver2000.databases.aspfaq.com/how-do-i-determine-if-a-table-exists-in-a-sql-server-database.html[^]

1.

IF EXISTS (SELECT 1 
           FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_TYPE='BASE TABLE' 
           AND TABLE_NAME='mytablename') 
   SELECT 1 AS res ELSE SELECT 0 AS res;

2.

IF OBJECT_ID (N'".

这篇关于检查Sql Database中是否存在表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！