To Work With Catalog Database Tables

You can add or edit catalog database tables for both the supported databases: Microsoft® Access and Microsoft® SQL™ Server .

Add a Catalog Table

1. Click Project tabOther Tools panel Add Table to Catalog Database. Find
2. Select the catalog database file.
3. Enter the table name.
4. Enter a description for the table which is added to the _FAMILY_DESCRIPTION table.
5. Click OK.

Add an _PINLIST Table

1. If the Catalog Browser is not open, click Schematic tabInsert Components panelInsert Components drop-downCatalog Browser. Find
2. Select the category you want to edit.
3. Perform a search to display the records you want to edit.
4. Click to open edit mode.
5. In either an existing record or a new record, enter the manufacturer value for the _PINLIST table you want to create.
6. Enter values as needed in the record.
7. Click to save all changes.

The _PINLIST table is added for the manufacturer value entered. For example, if the new manufacturer value you entered is AAA, an _PINLIST_AAA table is created.

Add an _TERMPROPS Table

1. If the Catalog Browser is not open, click Schematic tabInsert Components panelInsert Components drop-downCatalog Browser. Find
2. Select the TRMS category.
3. Perform a search to display the records you want to edit.
4. Click to open edit mode.
5. In either an existing record or a new record, enter the manufacturer value for the _TERMPROPS table you want to create.
6. Enter values as needed in the record.
7. Click to save all changes.

The _TERMPROPS table is added for the manufacturer value entered. For example, if the new manufacturer value you entered is AAA, an _TERMPROPS_AAA table is created.

Remove a Table

Use a database editor to remove a table. The steps described use Microsoft® Access.

1. In Project Manager, right-click the project name and select Settings to find the location of the catalog database file.
2. Open the file in Access.
3. Right-click the table name in the list of tables.
4. Click Delete.

Rename a Table

Use a database editor to rename a table. The steps described use Microsoft® Access.

1. In Project Manager, right-click the project name and select Settings to find the location of the catalog database file.
2. Open the file in Access.
3. Right-click the table name in the list of tables.
4. Click Rename.
5. Type the new table name.

Important: Before renaming a table, make sure that you understand the catalog table naming conventions. Incorrect table names can cause issues during a catalog lookup.

Edit Column Labels

Use a database editor to rename a table. The steps described use Microsoft® Access.

1. In Project Manager, right-click the project name and select Settings to find the location of the catalog database file.
2. Open the file in Access.
3. Double-click the table name in the list of tables.
4. Click Home tab Views tab View Design View.
5. Edit the field names as needed.
   Note: Do not change the field properties; data type and length.
6. Save the database design changes.

Add a Column in a Catalog Table

Use a database editor to rename a table. The steps described use Microsoft® Access.

1. In Project Manager, right-click the project name and select Settings to find the location of the catalog database file.
2. Open the file in Access.
3. Double-click the table name in the list of tables.
4. Click Home tab Views tab View Design View.
5. If the table contains a RECNUM field at the end, right-click on the RECNUM row to add the new field before the RECNUM field.
   Note: Do not add fields before any of the other existing fields.
6. Click Insert Rows.
7. Enter a field name.
8. Update field properties; data type and length.
9. Save the database design changes.

Important: Do not add columns to any of the tables that begin with an underscore.