- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 5.1 Reference Manual :: 12 SQL Statement Syntax :: 12.5 Database Administration Statements :: 12.5.5 SHOW Syntax :: 12.5.5.6 SHOW CREATE DATABASE Syntax
Section Navigation [Toggle]
- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW AUTHORS Syntax
- 12.5.5.2 SHOW CHARACTER SET Syntax
- 12.5.5.3 SHOW COLLATION Syntax
- 12.5.5.4 SHOW COLUMNS Syntax
- 12.5.5.5 SHOW CONTRIBUTORS Syntax
- 12.5.5.6 SHOW CREATE DATABASE Syntax
- 12.5.5.7 SHOW CREATE EVENT
- 12.5.5.8 SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax
- 12.5.5.9 SHOW CREATE TABLE Syntax
- 12.5.5.10 SHOW CREATE TRIGGER Syntax
- 12.5.5.11 SHOW CREATE VIEW Syntax
- 12.5.5.12 SHOW DATABASES Syntax
- 12.5.5.13 SHOW ENGINE Syntax
- 12.5.5.14 SHOW ENGINES Syntax
- 12.5.5.15 SHOW ERRORS Syntax
- 12.5.5.16 SHOW EVENTS
- 12.5.5.17 SHOW GRANTS Syntax
- 12.5.5.18 SHOW INDEX Syntax
- 12.5.5.19 SHOW INNODB STATUS Syntax
- 12.5.5.20 SHOW OPEN TABLES Syntax
- 12.5.5.21 SHOW PLUGINS Syntax
- 12.5.5.22 SHOW PRIVILEGES Syntax
- 12.5.5.23 SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax
- 12.5.5.24 SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax
- 12.5.5.25 SHOW PROCESSLIST Syntax
- 12.5.5.26 SHOW SCHEDULER STATUS Syntax
- 12.5.5.27 SHOW STATUS Syntax
- 12.5.5.28 SHOW TABLE STATUS Syntax
- 12.5.5.29 SHOW TABLES Syntax
- 12.5.5.30 SHOW TRIGGERS Syntax
- 12.5.5.31 SHOW VARIABLES Syntax
- 12.5.5.32 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.
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 12.5.4, “SET Syntax”.
© 1995-2008 MySQL AB. All rights reserved.
User Comments
Add your own comment.