SQL SYS.Database table not found
Hi,
I running an SQL so I can find the databases with the largest amount of free space. This is in case I can compact the databases.
However SQL cannot find the SYS.Database table.
Can someone please explain how to fix?
[SQL]TEST:%SYS>>select * from SYS.Database
ERROR #5540: SQLCODE: -30 Message: Table 'SYS.DATABASE' not found
[SQL]TEST:%SYS>> << entering multiline statement mode, 'GO' to execute >>
1>>select DatabaseName, Directory, Size, Free, DiskFreeSpace
2>>from SYS.Database
3>>order by DiskFreeSpace DESC
4>>go
ERROR #5540: SQLCODE: -30 Message: Table 'SYS.DATABASE' not found
The documentation I'm using is:
https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…
This states:
SQL Table Name: SYS.Database
Thanks
Discussion (0)0
Comments
Sorting is useless, but anyway
.png)
Thanks. Works like a dream!