Some Queries for Storage Manager. Have to confirm requirements and add queries below
Database
-----------
SELECT DATABASENAME,DBKIND,PERMSPACE,SPOOLSPACE,TEMPSPACE,ACCOUNTNAME FROM DBC.DATABASES ORDER BY DATABASENAME
GO
Tables
--------
have to join databasespaces and tables
SELECT * FROM DBC.DATABASESPACE
GO
Indexes
----------
SELECT * FROM DBC.indices
GO
Issue #2771 |
Closed |
Completion |
No due date |
No fixed build |
No time estimate |