docs.intersystems.com
Home  /  Application Development: Additional Options  /  InterSystems Programming Tools Index  /  Tools Index  /  DDL


InterSystems Programming Tools Index
DDL
[Back]  [Next] 
InterSystems: The power behind what matters   
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
InterSystems SQL
InterSystems SQL includes support for SQL DDL. For information, see the following chapters of Using InterSystems SQL:
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:
Some of these methods require specific permissions.
Availability: All namespaces.
Reminder
The special variable $SYSTEM is bound to the %SYSTEM package. This means that instead of ##class(%SYSTEM.class).method(), you can use $SYSTEM.class.method().
See Also