Estimating the Extra Space Required by a Column

If the auto identity option is set in a database, the SAP ASE server automatically defines a 10-digit IDENTITY column in each new table that is created without specifying a primary key, a unique constraint, or an IDENTITY column. To estimate how much extra space is required by this column:

  1. In the master database, use sp_dboption to turn on the auto identity option for the database.
  2. Create the table.
  3. Run sp_estspace on the table and record the results.
  4. Drop the table.
  5. Turn the auto identity option off for the database.
  6. Re-create the table.
  7. Rerun sp_estspace on the table, and record the results.