To set table properties:

  1. Double-click the Table node in the tree.

  2. Double-click the table you want to modify. The Schema page is displayed.

  3. Select the Properties tab. The Properties page is displayed.

  4. If you wish to change the lock mode, choose a different lock mode from the default setting.

  5. To change the fill factor, enter a percentage in the Fill Factor field.

  6. Select the no-cache check box if you want only one page buffer to cache the data retrieved from the table.

  7. To reset the serial number for a serial type column in the table, enter the starting number of the column in the Serial box.

  8. Click Confirm. The properties of the table are modified.


Related topic:

Setting Table Properties