SHOW DATABASES

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

SHOW DATABASES

• 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: “”