Switch to: V11V10V9V8V7V6V5

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.