A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Functions: System Functions

pointer_size()

The system function pointer_size() determines, if the current version of ASE is a 32-bit or 64-bit version. The return value of the function "pointer_size()" can either be 4, when executing against a 32-bit installation, or 8 on a 64-bit installation. This information is also contained in the value stored in the global variable @@version. The system function "pointer_size()" cannot be found in the official Sybase documentation.

Syntax of the System Function pointer_size()

    pointer_size()
    

The parameter of the System Function pointer_size()

The system function "pointer_size()" does not require any parameters.

Example for the System Function pointer_size()

    select pointer_size()
    go
    ----------- 
              8
    

The return value identifies th current installation of ASE as a 64-bit version.

See also:

ASE T-SQL - Aggregate Functions,
audit_event_name(),
col_length(),
col_name(),
curunreservedpgs(),
datachange(),
datalength(),
data_pages(),
data_pgs(),
db_id(),
db_name(),
host_id(),
host_name(),
identity(),
index_col(),
index_colorder(),
isnull(),
lct_admin(),
license_enabled(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pagesize(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
syb_sendmsg(),
System Functions,
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().