Updating the primary key
Valid options for this parameter are all, tabs or none.
Every CREATE TABLE statement must specify a name for the new table.
If there is no explicit DEFAULT clause attached to a column definition, then the default value of the column is NULL.
An explicit DEFAULT clause may specify that the default value is NULL, a string constant, a blob constant, a signed-number, or any constant expression enclosed in parentheses.
It is usually an error to attempt to create a new table in a database that already contains a table, index or view of the same name.But this has no performance impact for most applications.And if your application has to persist a huge number of new entities, you can use some Hibernate specific optimizations to reduce the number of statements.However, if the "IF NOT EXISTS" clause is specified as part of the CREATE TABLE statement and a table or view of the same name already exists, the CREATE TABLE command simply has no effect (and no error message is returned).An error is still returned if the table cannot be created because of an existing index, even if the "IF NOT EXISTS" clause is specified. AS SELECT" statement creates and populates a database table based on the results of a SELECT statement.
This is usually used as the source of an iframe for embedding Campaign Monitor within your own application.