MS SQL Server
Find Number Of Table in Database Query
Write SQL Query to Find No. Of Table in Database
USE
YOURDBNAME
--Database Name
SELECT
COUNT
(*)
from
information_schema
.
tables
WHERE
table_type
=
'base table'
Newer Post
Older Post
Home