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

Purpose of Query

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

Applicable CAST Version

ReleaseYes/No
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS2✅

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