1

常见数据库中判断表、字段是否存在的SQL语句

 1 year ago
source link: https://xushanxiang.com/sql-table-field-exist.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

常见数据库中判断表、字段是否存在的SQL语句

作者: xusx 分类: MySQL 发布时间: 2022-06-30 08:55 浏览：16
sql.png

判断一个表是否存在

MySQL

SELECT table_name FROM information_schema.TABLES WHERE table_name='表名';
# 返回表名或NULL，直接判断
# 或者：
select count(*) from information_schema.tables where table_name='表名';
# 返回1 or 0, 需要再次判断

MSSQL Server

select count(*) from dbo.sysobjects where name='表名';

PostgreSQL

select count(*) from information_schema.tables where table_schema='table_schema' and table_name='表名';

Oracle

select count(*) from user_objects where object_name='表名';

Sqlite

select count(*) from sqlite_master where type='table' and name='表名';

判断表中一个字段是否存在

MySQL

select count(*) from information_schema.columns where table_name = '表名' and column_name='字段名';

MSSQL Server

select count(*) from syscolumns where id=object_id('表名') and name= '字段名';

PostgreSQL

select count(*) from information_schema.columns where table_schema='table_schema' and table_name='表名' and column_name='字段名';

Oracle

select count(*) from user_tab_columns where table_name='表名' and column_name='字段名';

Sqlite

select count(*) from sqlite_master where name='表名' and sql like '字段名'

如果觉得我的文章对您有用，请随意赞赏。您的支持将鼓励我继续创作！


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK