This section provides SQL queries that can be run on all CAST Databases
- SQL Queries - Common SQL Queries - Corruptions
- SQL Queries - Common SQL Queries - How to check if a database has been restored on Oracle or SQL Server after being initially created
- SQL Queries - Common SQL Queries - How to check the consistency on existing objects between the central and local databases
- SQL Queries - Common SQL Queries - How to check the consistency on the next value to be allocated on local database for an Id
- SQL Queries - Common SQL Queries - How to check the database migration history
- SQL Queries - Common SQL Queries - How to check the database type
- SQL Queries - Common SQL Queries - How to check the postgres sessions that are blocking another session
- SQL Queries - Common SQL Queries - How to check the table size and corresponding index sizes on a schema
- SQL Queries - Common SQL Queries - How to count the number of indexes in a schema
- SQL Queries - Common SQL Queries - How to deduplicate a table
- SQL Queries - Common SQL Queries - How to get postgres log files
- SQL Queries - Common SQL Queries - How to get the list of installed extensions
- SQL Queries - Common SQL Queries - How to get the size of schemas and temporary space on PostgreSQL database
- SQL Queries - Common SQL Queries - How to modify existing version name in all components
- SQL Queries - Common SQL Queries - How to remove all objects in an oracle schemas KB CB and MNGT which is used as CAST service
- SQL Queries - Common SQL Queries - How to retrieve the count of indexes used for a schema
- SQL Queries - Common SQL Queries - How to retrieve the id and the name of all types of a UA language
- SQL Queries - Common SQL Queries - How to retrieve the primary key of a table
- SQL Queries - Common SQL Queries - Queries on Indexes - How to get indexes and how to compare them with Standard CAST Database Indexes
- SQL Queries - Common SQL Queries - Queries on Installation - Update the Unique Service ID
- SQL Queries - Common SQL Queries - Queries on metamodel - How to get the list of duplicated metamodel
- SQL Queries - Common SQL Queries - Queries on metamodel - How to get the list of ids with null metamodel values
- SQL Queries - Common SQL Queries - Queries on Metrics - How to determine whether a metric is unified
- SQL Queries - Common SQL Queries - Queries on Metrics - How to get a list of all Quality rules in KB or CB
- SQL Queries - Common SQL Queries - Queries on Metrics - How to get ids of metrics given part of the name of the metric
- SQL Queries - Common SQL Queries - Queries on Metrics - How to get information on activated or enabled quality rules
- SQL Queries - Common SQL Queries - Queries on Modules - How to get the count of objects in the modules based on its type
- SQL Queries - Common SQL Queries - Queries on Objects - How to get the extract of the content of applications in all snapshots
- SQL Queries - Common SQL Queries - Queries on Source Code - How to remove source code from CAST databases
- SQL Queries - Common SQL Queries - How to get Assessment Model Information for whole database server
- SQL Queries - Common SQL Queries - SQL Query to list Schema name with their disk space utilization in Postgres Database
