Did you know ... | Search Documentation: |
CQL: Schema |
These define the schema. You MUST either define them, or include
library(cql/cql_autoschema)
and add two directives to build
the schema automatically:
:-
register_database_connection_details(+Schema, +ConnectionInfo)
.:-
build_schema(+Schema)
.Otherwise, you need to define at least cql:default_schema/1 and cql:dbms/2, and then as many of the other facts as needed for your schema.
default_schema(-Schema)
MUST be defined. CQL
autoschema will define this for you if you use it.dbms(+Schema, -DBMS)
MUST be defined for every
schema you use. CQL autoschema will define this for you if you use it.
DBMS must be one of the following:
odbc_data_type(+Schema, +TableName, +ColumnName, +OdbcDataType)
.primary_column_name(+Schema, +Tablename, +ColumnName)
.allows_nulls(true/false)
, +IsIdentity:is_identity(true/false)
,
+ColumnDefault).database_domain(+DomainName, +OdbcDataType)
.routine_return_type(+Schema, +RoutineName, +OdbcDataType)
.database_constraint(+Schema, +EntityName, +ConstraintName, +Constraint)
.