Chapter 2 Physical Data Model Basics

Creating a database in a model

In those DBMS that support this feature, you can create as many databases as you need in you model, the databases appear in a list of objects, available from the Model menu. In other DBMS, you create only one database per model from the model property sheet.

Steps To create a database in a model:

  1. Select Model→Databases to display the List of Databases.
  2. Click the Add a row tool to insert a new database in the list.
  3. Click Apply.
  4. Click the Properties tool to display the database property sheet.
  5. Type a new name and code for the database in the General page.
  6. <optional> Define the database physical options in the Options page.
  7. <optional> Type a database begin and end script in the Script page.
  8. Click OK.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.