MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax :: 12.4 Database Administration Statements :: 12.4.5 SHOW Syntax :: 12.4.5.6 SHOW CREATE DATABASE Syntax
Section Navigation [Toggle]
- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW BINARY LOGS Syntax
- 12.4.5.2 SHOW BINLOG EVENTS Syntax
- 12.4.5.3 SHOW CHARACTER SET Syntax
- 12.4.5.4 SHOW COLLATION Syntax
- 12.4.5.5 SHOW COLUMNS Syntax
- 12.4.5.6 SHOW CREATE DATABASE Syntax
- 12.4.5.7 SHOW CREATE FUNCTION Syntax
- 12.4.5.8 SHOW CREATE PROCEDURE Syntax
- 12.4.5.9 SHOW CREATE TABLE Syntax
- 12.4.5.10 SHOW CREATE VIEW Syntax
- 12.4.5.11 SHOW DATABASES Syntax
- 12.4.5.12 SHOW ENGINE Syntax
- 12.4.5.13 SHOW ENGINES Syntax
- 12.4.5.14 SHOW ERRORS Syntax
- 12.4.5.15 SHOW FUNCTION CODE Syntax
- 12.4.5.16 SHOW FUNCTION STATUS Syntax
- 12.4.5.17 SHOW GRANTS Syntax
- 12.4.5.18 SHOW INDEX Syntax
- 12.4.5.19 SHOW INNODB STATUS Syntax
- 12.4.5.20 SHOW LOGS Syntax
- 12.4.5.21 SHOW MASTER STATUS Syntax
- 12.4.5.22 SHOW MUTEX STATUS Syntax
- 12.4.5.23 SHOW OPEN TABLES Syntax
- 12.4.5.24 SHOW PRIVILEGES Syntax
- 12.4.5.25 SHOW PROCEDURE CODE Syntax
- 12.4.5.26 SHOW PROCEDURE STATUS Syntax
- 12.4.5.27 SHOW PROCESSLIST Syntax
- 12.4.5.28 SHOW PROFILE Syntax
- 12.4.5.29 SHOW PROFILES Syntax
- 12.4.5.30 SHOW SLAVE HOSTS Syntax
- 12.4.5.31 SHOW SLAVE STATUS Syntax
- 12.4.5.32 SHOW STATUS Syntax
- 12.4.5.33 SHOW TABLE STATUS Syntax
- 12.4.5.34 SHOW TABLES Syntax
- 12.4.5.35 SHOW TRIGGERS Syntax
- 12.4.5.36 SHOW VARIABLES Syntax
- 12.4.5.37 SHOW WARNINGS Syntax
SHOW CREATE {DATABASE | SCHEMA} db_name
Shows the CREATE DATABASE
statement that creates the given database.
SHOW
CREATE SCHEMA is a synonym for
SHOW CREATE DATABASE as of MySQL
5.0.2.
mysql>SHOW CREATE DATABASE test\G*************************** 1. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ mysql>SHOW CREATE SCHEMA test\G*************************** 1. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */
SHOW CREATE DATABASE quotes table
and column names according to the value of the
sql_quote_show_create option.
See Section 5.1.4, “Session System Variables”.
User Comments
Add your own comment.