602SQL Documentation Index  

Database Applications (Schemas)


A database application in 602SQL can be into the following:

The schema concept is used for the same set of objects in SQL language.

Application Name and ID

An application name has to fulfill the rules for an identifier (i.e. maximum number of characters is 31) and mustn't contain a dot ("."). An application has a unique binary identification (UUID). Function Current_application, Local_schema_name or Schema_uuid serves for getting names or UUID. Application UUID is used in some system queries.

Creating and Deleting

Applications are created and deleted in the Control Panel of the 602SQL Client. There are also SQL statements CREATE SCHEMA and DROP SCHEMA.

An application may be exported and then imported to another SQL Server.

List of topics: