Search
 
SCRIPT & CODE EXAMPLE
 

SQL

count mysql server db tables

SELECT count(*)
   FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_SCHEMA = 'yourDatabaseName';
Comment

PREVIOUS NEXT
Code Example
Sql :: how to delete view in sql 
Sql :: postgres delete last row 
Sql :: sql find missing values between two tables 
Sql :: how much every mysql database record takes from diskspace 
Sql :: oracle detect invalid password 
Sql :: sql server 2012 query history 
Sql :: show sqlite column names 
Sql :: psql restore from tar 
Sql :: sql reset auto increment 
Sql :: sqlite foreign key 
Sql :: tsql find foreign key references 
Sql :: sql where last 12 months 
Sql :: insert all or first in oracle sql 
Sql :: oracle export trigger ddl 
Sql :: set permanent SET GLOBAL sql_mode ubuntu 
Sql :: python how to connect to sql server 
Sql :: mysql drop column 
Sql :: mysql user permission database 
Sql :: oracle export view ddl 
Sql :: change table to innodb mysql 
Sql :: mysql trigger after update 
Sql :: postgresql if null then 0 
Sql :: sql select except null 
Sql :: sql query inline if 
Sql :: view linked servers 
Sql :: difference between where and having clause 
Sql :: mysql all columns 
Sql :: how to create an empty table from an existing table 
Sql :: script to add datafile to tablespace 
Sql :: mysql backup skip table 
ADD CONTENT
Topic
Content
Source link
Name
3+9 =