|
System Functions
System Functions are functions in
ASE®
used to
query
and display system relevant information about
databases
and
objects.
System functions can be nested and used in the
where
clause
of a
select
query or whereever so-called
expressions can be used. To use
constants
in a string function, they should be set in single or double quotes. The names of system functions are not
reserved words.
When specifing optional
parameters,
it is assumed that queries are performed on the current database, server (host) or
User.
System functions recognise
parameters,
which can be automatically converted into the correct
datatype
using
implicity conversion.
List of ASE System Functions
ASE®
provides a number of system functions:
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(),
pointer_size(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
syb_sendmsg(),
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().
|
