Using a Data Definition File
Go Up to Using the Data Definition Guide
A data definition file can include statements to create, alter, or drop a database, or any other SQL statement. To issue SQL statements through a data definition file, follow these steps:
- 1. Use a text editor to create the data definition file. Each DDL statement should be followed by a
COMMITto ensure its visibility to all subsequent DDL statements in the data definition file.
- 2. Save the file.
- 3. Input the file into isql. For information on how to input the data definition file using Windows ISQL, see the Operations Guide. For information on how to input the data definition file using command-line isql, see the Operations Guide