Only the queries that are solely based on INFORMATION_SCHEMA are potentially usable in case of other DBMSs.
Solely based on INFORMATION_SCHEMA (opens in new tab)
Queries: 22420.0%
Solely based on the system catalog (opens in new tab) or system information functions (opens in new tab)
Queries: 20919.0%
Use both INFORMATION_SCHEMA and system catalog/system information functions
Queries: 63959.0%
| Source Name | Number of Queries | Percentage |
|---|---|---|
| Solely based on INFORMATION_SCHEMA (opens in new tab) | 224 | 20.0% |
| Solely based on the system catalog (opens in new tab) or system information functions (opens in new tab) | 209 | 19.0% |
| Use both INFORMATION_SCHEMA and system catalog/system information functions | 639 | 59.0% |