Table of Contents
SHOW STATUS OF DATABASE
This command shows statistic parameters of the specified Valentina Database. If the database name is absent, then the active database is used.
Syntax
SHOW STATUS {OF|FOR} DATABASE [name]
Result Columns
fld_name
The name of STATUS parameter.
fld_value
The value of STATUS parameter.
fld_level
The level of STATUS parameter.
STATUS PARAMETERS
COMMIT
The Counter of calls to Commit().
CREATE INDEX STYLE
The counter of calls to VDatabase.CreateIndexStyle().
CREATE LINK
The counter of calls to VDatabase.CreateLink().
CREATE STORED PROCEDURE
The counter of calls to VDatabase.CreateProcedure().
CREATE TABLE
The counter of calls to VDatabase.CreateTable().
CREATE TABLE SYSTEM
The counter of VDatabase.CreateSystemTable() calls.
CREATE TABLE TMP
The counter of VDatabase.CreateTmpTable() calls.
CREATE TRIGGER
The counter of VDatabase.CreateTrigger() calls.
CREATE VIEW
The counter of VDatabase.CreateView() calls.
DROP INDEX STYLE
The counter of calls to VDatabase.DropIndexStyle().
DROP LINK
The counter of calls to VDatabase.DropLink().
DROP STORED PROCEDURE
The counter of calls to VDatabase.DropStoredProcedure().
DROP TABLE
The counter of calls to VDatabase.DropTable().
DROP TRIGGER
The counter of calls to VDatabase.DropTrigger().
DROP VIEW
The counter of calls to VDatabase.DropView().
EXECUTE
The counter of calls to VDatabase.SqlExecute().
FLUSH
The counter of calls to VDatabase.Flush().
POOL_USAGE
The counter of successfull finds of an SQL query in the pool of queries.
ROLLBACK
The count of rollbacks for this database.
SELECT
The counter of calls to VDatabase.SqlSelect().