Skip to main content
IBM Skip to main content
spHome | Products & services | Support & downloads | My account
Software > DB2 > DB2 Developer Domain
Developing DB2 schema using IBM Explorer in VS.NET
ZIPPDF (letter)PDF (A4)e-mail
Main menuSection menuFeedbackNext
Creating the database schema
  


OverviewPage 1 of 5


This section describes the steps required to create the following database schema objects:

  • The Inventory, and the InventoryHistory tables
  • The InventoryName index
  • The LowInventory view

Using double quotes for SQL identifier
Throughout this section, use double quotes for various SQL identifiers, such as table names, column names, view names, ...etc. Double quotes preserve the lower/upper case mixing in these identifiers, and support blanks when and where required. If you don't use quotes, SQL identifiers will automatically be uppercase.

Using the DB2 database project:
Note that the DB2 Project Selection step is not included in most of the wizards used in the tutorial. This step allows you to specify a target DB2 database project for which to add the script files the get generated to create the various DB2 objects. I would strongly recommend that you use this option, as you be able to save your script files for further editing and re-deployment to other database servers.


Main menuSection menuFeedbackNext
About IBM | Privacy | Legal | Contact