Home > Database > Mysql Tutorial > SqlServer/MySql查询某个数据库中表的数量_MySQL

SqlServer/MySql查询某个数据库中表的数量_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:31:03
Original
1271 people have browsed it

bitsCN.com

SqlServer/MySql查询某个数据库中表的数量

 

MySql的统计方法

 

SELECT count( * ) FROM information_schema.tables WHERE TABLE_SCHEMA = '库名'
Copy after login

SqlServer的统计方法

select count(*) as TableCount from sysobjects where type='u' and status>=0
Copy after login


bitsCN.com
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