Database Setup dialog box

Used to create, review, and modify MSCATALOG and also to create and drop tables in the connected external database.

Open the Database Setup setting box from Settings > Database > Setup.

Clicking the OK or Cancel button does not effect table creation or dropping operations that are initiated and completed using this settings box. These operations result in immediate modification of the database.

The Database Setup dialog box is similar to the MSCATALOG dialog box in Version 5.0.

Tables

Lists each table for which a row exists in MSCATALOG. The MSCATALOG values for the selected table are displayed for modification in the fields. To modify the MSCATALOG values for a table, you must first select it.

Entity Number

Sets the unique entity or table number for the selected table (the entitynum value in the MSCATALOG row for the table).

Largest MSLINK

Shows the largest mslink key value in the selected table. MicroStation automatically adds 1 to this value when adding each new row to the database.

Attribute Review

Contains fields for setting the column values in the MSCATALOG row for the selected table that affect reviewing and reporting the database attributes of elements.

Screen Form

Sets the default screen form, used in conjunction with the Review Database Attributes of Element tool, to review the database attributes of elements linked to rows in the selected table. This is the screenform value in the MSCATALOG row for the table.

Report Table

Sets the name of the report table that can be created with the Generate Report Table tool to report on the database attributes of elements linked to rows in the selected table. This is the reporttable value in the MSCATALOG row for the table.

Key-in: ACTIVE REPORT <table:report_table>

or

Key-in: RS= <table:report_table>

SQL Review

Sets the SQL SELECT statement that is submitted with the Review Database Attributes of Element tool to review database attributes of elements linked to rows in the selected table. This is the sqlreview value in the MSCATALOG row for the table.

Key-in: ACTIVE REVIEW SQL SELECT statement

or

Key-in: RA= <SQL_SELECT_statement>

Filter

Sets the SQL SELECT statement that determines which elements linked to rows in the selected table are selected for fence operations. This is the fencefilter value in the MSCATALOG row for the table.

Key-in: DEFINE SEARCH <SQL SELECTstatement >

or

Key-in: DS= <SQL_SELECT_statement>

DAS Table

Sets the name of the displayable attributes table that is used to determine which attributes of elements linked to rows in the selected table display in displayable attribute text nodes, and whether screen forms are used to display the attributes. This is the dastable value in the MSCATALOG row for the table.

Table menu > Add to MSCATALOG

Opens the Add Table dialog box, which is used to specify a table for which a row is to be inserted into MSCATALOG.

Table menu > Delete from MSCATALOG

Deletes the selected table from MSCATALOG.

Table menu > Create…

Opens the Create Table dialog box, which is used to create tables in the connected database.

Table menu > Drop…

Opens the Drop Table dialog box, which is used to drop a table from the connected database.

OK

Accepts modifications to MSCATALOG and closes the dialog box.

Cancel

Closes the dialog box without effecting any changes to MSCATALOG.