Syntax Elements

current
Identifies a version as the current version and its immediate successor (if any) as the in-work version.

namespace
Organizes database classes into logical namespaces.

integer
Represents the integer client type.

real
Represents the floating point client type.

datetime
Represents the date and time client type.

string
Represents the string client type.

as
Maps a logical type to a client type.

binding
Binds a piece of a sql construction step to the physical name of a design element.

hash
Fixes the hash code of a version in place so that you get a compiler error if you accidentally change scripts that have already been run in production.

types
Declares the base types used by a database class.

type
Identifies a specific type, including precision, scale, length, and nullness.

database
Declares that a database class is to be built.

version
Declares a version of a database class.

:
Declares that the symbol on the left hand side inherits from the symbol on the right.

design
Begins the design block of a database version.

open curly
Starts a block - a logical grouping of statements, clauses, or declarations.

close curly
Ends a block - a logical grouping of statements, clauses, or declarations.

construction
Begins declaring a construction block - the series of steps required to advance a database one version or initialize it.

step sql
Declares the beginning of a construction step.

initialized
A special version number.

version number
The identifier for a version of a database class.

stereotypes
Declares the stereotypes used to define the design of a database.

with
Declares a list of attributes for a design element.

with validation
Defines the level of built-in validation used by a design stereotype

minimal
When used to specify a validation level, declares that there is some minimal validation.

table
A special stereotype that can cause code generation activities.

column
A special stereotype that can cause code generation activities.

procedure
A special stereotype that can cause code generation activities.

removed
Eliminates an inherited trait from a design element.

null
Indicates that a type is nullable.

parameter
A special stereotype that can cause code generation activities.

result
A special stereotype that can cause code generation activities.

none
When used to specify a validation level, declares that there is no validation.

public
Specifies that a design element is publicly visible.

protected
Specifies that a design element is visible only to inheritors of the containing element.

in context
Switches the context of contained construction steps to be the specified design element.

physical name
Allows you to specify a physical (database-internal) name for design element that is different from the logical (public-facing) name.

Other Actions

documentation | all examples | use cases | concepts | keywords