Switch to: V9V8V7V6V5

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().