Run the Domains.sql Script

1. Open Domains.sql in a text editor and make sure that the CONNECT statement specifies the correct path, database name, user name, and password.
2. Notice that the file contains many descriptive passages that are commented out. The convention for comments is exactly like that for the C language: comments begin with /* and end with */.
3. Look through the file and notice that each SQL statement ends with a semicolon (;). Semicolons are required at the end of each statement in a data definition file. They are not required when you type statements directly into IBConsole.
4. Choose Query > Load Script. The Load SQL Script dialog displays:

5. Navigate to the location where you have stored the tutorial SQL files, highlight Domains.sql and click Open.
6. Choose Query > Execute.
   
   Troubleshooting: If you receive a message stating that there are errors, read the log file, in this case Domains.log, which is located in the \scripts directory. Also check that the CONNECT information (database, user, and password) in the script file is correct.
   
   
7. To confirm that the domains now exist, click on Domains in the left pane of IBConsole.

   You should see all the domains defined for the database displayed in the right pane of IBConsole. You should see the following domains:

   

   Note: You can choose to show or hide the systems data (for example the RDB$ domains) by choosing IBConsole > View > System Data.

Advance To:

Creating Tables