Switch to: V9V8V7V6V5

SHOW DATABASES

SHOW DATABASES lists all databases on the Valentina Server. SHOW SCHEMAS is a synonym for SHOW DATABASES.

Syntax

SHOW DATABASES

Result Columns

  • fld_name

The name of the Database.

  • fld_locale

The database locale.

  • fld_encoding

The database storage encoding.

  • fld_table_count

The count of tables in the current database.

  • fld_link_count

The count of links in the current database.

  • fld_idents_case_sensetive

TRUE if for this database is enabled case-sensetivity for not quoted idents. On default it is FALSE, i.e. “tblPerson” is the same to “TBLPERSON”.

  • fld_registered

[NEW in v5.0]

TRUE if this database is registered in the master database, so users can open it. FALSE if database present in the vserver/databases folder, but is not registered, so user should at first do 'REGISTER DATABASE dbname' command.

  • fld_exists

[NEW in v5.0]

TRUE if this database exists on the disk in the location as it was registered into master database.

  • fld_ACL

[NEW in v6.0]

Access Control List of database. “ACL” is vServer specific database's property. ACL is a comma separated list of IP subnets, each subnet is prepended by '-' or '+' sign. Plus means allow, minus means deny. If subnet mask is omitted, like ”-1.2.3.4”, then it means single IP address. Mask may vary from 0 to 32 inclusive. On each request, full list is traversed, and last match wins. For example, to allow only 192.168/16 subnet to connect, run ”-0.0.0.0/0,+192.168.0.0/16”. Default: ””