Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to SQL Anywhere property sheets

Table property sheet: Permissions tab Next Page

Table property sheet: Miscellaneous tab

The Miscellaneous tab of the Table property sheet has the following components:

Maximum table width    Shows the number of bytes required for each row in the table. The number is calculated from the length of the string columns, the precision of numeric columns, and the number of bytes of storage for all other data types. If the table includes LONG BINARY, or LONG VARCHAR columns, their arbitrary widths are not included, so the row width can only be approximated.

Number of rows    Shows the approximate number of rows in the table. To update this value, click Calculate.

Free space    Specifies the amount of free space you want to reserve for each table page. The free space is used if rows increase in size when the data is updated. If there is no free space in a table page, every increase in the size of a row on that page requires the row to be split across multiple table pages, causing row fragmentation and possible performance degradation.

See ALTER TABLE statement.

Table is replicating data    Select this option to include the table as part of a replication primary site. This only applies to base tables.

Table data is encrypted    Select this option to encrypt this table's data, when the database is created with table encryption scope. This only applies to base tables.

For more information about replication primary sites, see Primary site components.

See also