DDL

InterSystems Programming Tools Index

DDL

[Home] [Back] [Next]

InterSystems: The power behind what matters

Caché Development References > InterSystems Programming Tools Index > Tools Index > DDL

Class Reference

Search:

Work with DDL statements and with DDL files.

Background Information

Generically, DDL means “data definition language,” which refers to syntax for defining data structures. SQL provides a set of statements for this purpose, and they are known collectively as SQL DDL. A DDL file is a text file that contains a series of these statements.

Available Tools

Caché SQL

Caché SQL includes support for SQL DDL. For information, see the following chapters of Using Caché SQL:

“Defining Tables”
“Defining Views”

These chapters discuss DDL as one of the techniques for defining tables and views.

Availability: All namespaces.

%SYSTEM.SQL class

Includes the following class methods for working with DDL files:

DDLImport()
DDLImportDir()
SetDDLDropTabDelData()
SetDDLIdentifierTranslations()
SetDDLNo201()
SetDDLNo30()
And others

Some of these methods require specific permissions.

Availability: All namespaces.

Reminder

The special variable $SYSTEM is bound to the %SYSTEM package. This means that (for ObjectScript) instead of ##class(%SYSTEM.class).method(), you can use $SYSTEM.class.method().