Developing and Deploying Siebel Business Applications > Configuring the House and Opportunity Entities > Process of Configuring the House Detail View >

Adding Columns to the Products Table

This task is a step in Process of Configuring the House Detail View.

In this topic, you add new columns to the base table and then apply these changes to your local database.

To add columns to the Products table

1. In the Object Explorer, click Table.
2. In the Tables list, locate the S_PROD_INT table.
3. Choose the Tools menu, and then the Lock Project menu item.

   Note the following:

   • The Project property is read-only for tables. You cannot change the value in the project property.
   • The Type property for the S_PROD_INT table is Data (Public). You can only extend a public table.
4. Add columns to the table:
   1. In the Object Explorer, expand the Table tree, and then click Column.
   2. In the Columns list, add a new column for each row listed in the following table.

      Name	Physical Type	Length
      X_ADDRESS	Varchar	30
      X_BATHROOMS	Varchar	30
      X_BEDROOMS	Varchar	30
      X_CITY	Varchar	30
      X_PRICE	Varchar	30
      X_STATE	Varchar	30
      X_SQFT	Varchar	30
      X_ZIP_CODE	Varchar	30

      The name of an extension column begins with the X_ prefix. For example, X_ADDRESS. The User Name of an extension column ends with the Ext suffix. For example, X_ADDRESS Ext. Siebel Tools automatically applies these formats.

5. Apply schema changes to the local database:
   1. In the Tables list, Click Apply/DLL.
   2. In the Choose option dialog box, accept the Apply default, and then click OK.
   3. In the Warning dialog box, click OK.
   4. In the Apply Schema dialog box, in the Tables window, choose Current Row.

      This setting updates the database to reflect the schema change to the row that is currently chosen in the Tables list. In this situation, that row is for the S_PROD_INT table only.

   5. Do not specify a table space or index space.
   6. Verify that the information in the ODBC Data Source text box is correct for your environment.

      You cannot apply a schema change to any database other than the one to which you are currently connected. If you are connected to the Sample database, then do the following:

      • Enter SIEBEL in the Database User window.
      • Enter SIEBEL in the Database User Password window.
      • Enter SEAW Samp Db default instance in the ODBC Data Source window.

        For more information, see Prototyping with the Sample Database.

   7. Click Apply.

      Siebel Tools applies the schema changes. The new columns you added now physically exist in your local database. They are available to use in your configuration.

Applying Schema Changes to the Server Database

Typically, after you test changes in the local database environment, you apply these changes to the server database. Checking in a project copies configuration changes to the Siebel Server, but it does not apply changes you make to the physical database. You must perform this work separately. For more information, see Configuring Siebel Business Applications.