EMS logo

Products Navigation

SQL Manager for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

On-line Documentation

Show database information


Show create database

Shows the CREATE DATABASE statement that creates the given database.

 

Show create database

 

Table displays database name and respective CREATE DATABASE statement.

 

 

Show open tables

Lists the non-TEMPORARY tables that are currently open in the table cache.

 

Show open tables

 

Table displays database name, where the table is contained, the table name, the number of table locks or lock requests for the table (In_use), and whether the table name is locked.

 

 

Show procedure status

Shows status of all procedures on the host.

 

Show procedure status

 

Table contains name of database where procedure is stored, procedure name, procedure type, procedure definer, date when the procedure was last modified, date when the procedure was created, security type (whether procedure executed using the invoker or definer privileges), brief comments, client character set name, collation of the connection character set, database collation.

 

 

Show table status

Lists non-temporary tables in the specified database and provides vary information about each table.

 

Show table status

 

Table contains name of the table, storage engine for the table, version number of the table's .frm file, row-storage format (Fixed, Dynamic, Compressed, Redundant, Compact), number of rows, average row length, length of the data file, maximum length of the data file, length of the index file, Data_free - number of allocated but unused bytes, next AUTO_INCREMENT value, Create_time - time when the table was created, Update_time - time when the data file was last updated, Check_time - time when the table was last checked, the table's character set and collation, the live checksum value (if any), Create_options -  extra options used with CREATE TABLE statement, the comment used when creating the table.

 

Show tables

Lists all tables of the selected database.

 

Show tables

 

Table displays names of tables stored in the database.

 

Show triggers

Lists the triggers currently defined for tables in a database.

 

Show triggers

 

Table displays trigger name, event that causes trigger activation (INSERT, UPDATE or DELETE), table for which trigger is defined, statement to be executed when trigger is activated, trigger timing (BEFORE or AFTER), Created (currently the value of this column is always NULL), SQL mode in effect when the trigger executes (starting from MySQL ver. 5.0.11), definer - account under which the trigger was created, client character set name, collation of the connection character set, database collation.