Updating identity column
This schema is read-only and contains some views and other schema objects. The catalog name has no relation to the file name of the database. Schema objects are database objects that contain data or govern or perform operations on data.
The views contain lists of all the database objects that exist within the catalog, plus all authorizations. A name is an identifier and is unique within its name-space. Each database has also an internal "unique" name which is automatically generated when the database is created. By definition, each schema object belongs to a specific schema.
By default, this schema is the initial schema when a new session is started.
New schemas and schema objects can be defined and used in the PUBLIC schema, as well as any new schema that is created by the user. Hyper SQL allows all schemas to be dropped, except the schema that is the default initial schema for new sessions (by default, the PUBLIC schema). CASCADE statement will succeed but will result in an empty schema, rather than no schema.
If a predefined character set is specified for a table column, then any string stored in the column must contain only characters from the specified character set.
For example, possible forms of the French collation are , etc.
The default database collation is the same as the system collation.
You can change this default, either with a language collation, or with the SQL_TEXT_UCC.
A different collation than the default collation can be specified for each table column that is defined as CHAR or VARCHAR. This collation is case insensitive, so the same name with different uses of upper and lower case letters is considered the same and counted together. You can use just the name in double quotes for the default form of the collation.
A collation can also be used in an ORDER BY clause. The supported collations are named according to the language. If you add a strength between 0, 1, 2, 3, the case sensitivity and accent sensitivity changes.If you change the database default collation afterwards, the new collation will be used.