pagesize

Returns the page size, in bytes, for the specified object.

Syntax

pagesize(object_name[, ])
pagesize(object_id[,db_id[, index_id]])

Parameters

Examples

Usage

  • pagesize defaults to the data layer if you do not provide an index name or index_id (for example, select pagesize("t1")) if you use the word “null” as a parameter (for example, select pagesize("t1", null).

  • If the specified object is not an object requiring physical data storage for pages (for example, if you provide the name of a view), pagesize returns 0.

  • If the specified object does not exist, pagesize returns NULL.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute pagesize.