DDL (Tools/APIs) Contents Background Information Available Tools Note See Also 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 Defining Tables and Defining Views, which discuss DDL as one of the techniques for defining tables and views.Availability: All namespaces. %SYSTEM.SQL.SchemaOpens in a new tab class Includes class methods for working with DDL files, including the following: ImportImport() ImportDDLDir() And others Some of these methods require specific permissions.Availability: All namespaces. Note 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 SQL
