SQL Queries - CAST Central Base - Queries on Objects - How to count the total number of objects

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

This page gives the SQL query to get the total number of objects in the Central base.

Applicable CAST Version
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (question)
Microsoft SQL Server (question)
CSS2 (tick)
Query for CSS
SELECT Count(1) 
FROM   dss_objects
Query result example

6711

Query result interpretation

In this example we have 6711 objects

Query for Oracle
Enter the SQL query
Query result example
 
Query result interpretation
 
Query for SQL server
Enter the SQL query
Query result example
 
Query result interpretation
 
Notes/comments
 
Related Pages