To set advanced table options:

  1. Follow the steps in the Create Table wizard until the Advanced Information window will open.

  2. If you want the table being created to be a temporary table, select the Temporary option button.

  3. If you wish to change the lock mode, choose a different lock mode from the default setting (page).

  4. To change the Fill Factor from the default 100%, enter a percentage in the Fill Factor field.

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

  6. Click Next. The Final review window will appear.


Related topic:

Setting Advanced Table Options
Completing Table Creation

To complete table creation

To add a foreign key during table creation