"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/create_schema.rst" (6 May 2012, 822 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

CREATE SCHEMA

CREATE SCHEMA enters a new schema into the current database. The schema name used must be distinct from the name of any existing schema.

CREATE SCHEMA [IF NOT EXISTS] schema_name
  [engine_options] ...

engine_options

You can specify the storage engine to use for creating the schema. Please note, there is currently only one engine.

engine_option [[,] engine_option] ...

collate

There are default settings for character sets and collations at four levels: server, database, table, and column. The COLLATE clause specifies the default database collation.

[DEFAULT] COLLATE = collation_name
{ engine_specific }

REPLICATE

Specify whether or not a SCHEMA should be replicated.

REPLICATE=[TRUE|FALSE]