SQL Script for creating Tables

  1. Select folder script from the directory where the CCI_Calendar resides.
  2. Select CCI_Calendar script file and double click to open the selected file.
  3. Right click to select all the contents of the CCI_Calendar script and then copy the selected texts.
  4. Highlight the CCI_Calendar database in SQL Server, then choose tool from the menu bar. Then, select the SQL Server Query Analyzer from the menu selection.
  5. Then copy all the texts from the CCI_Calendar Script onto the Query Analyzer.
  6. Click on Run button as indicated in Figure 2 below.
  7. You will see the confirmation saying that your command(s) completed successfully as shown in the lower pane of Figure 3.
  8. You can close the window to return to the Enterprise Manager to view the content of your tables.