Home > Database > Mysql Tutorial > body text

判断数据库中是否存在表

WBOY
Release: 2016-06-07 15:41:20
Original
1657 people have browsed it

1。Sqlite 数据库: select count(*) from sqlite_master where table=*** sqlite_master 是 sqlite维护的系统表 2。SqlServer2000数据库 if exists(select 1 from sysobjects where name='表名' and xtype='u') print '存在' else print '不存在' 3。SqlSer

1。Sqlite 数据库:

select count(*) from sqlite_master where table=***

 sqlite_master  是 sqlite维护的系统表

 

2。SqlServer2000数据库

 

if   exists(select   1   from   sysobjects   where   name='表名'   and   xtype='u')  
  print   '存在'  
  else   
  print   '不存在' 

 

3。SqlServer2005数据库

 

SELECT   ISNULL(OBJECTPROPERTY(OBJECT_ID('TableName'),   'IsUserTable'),   0)

存储过程中可以这样判断:
IF OBJECT_ID ('TableName', 'U') IS NOT NULL

 

4。access数据库

 SELECT Count(*) AS RTab FROM MSysObjects WHERE (((MSysObjects.Name) Like "需判断的已知表名"));

 

5。MySql数据库

 

select   1   from   information_schema.tables   where   table_name   =   'account';  
   
  if   found_rows()   =   1   then  
   
        ....  
   
  end   if;

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!