|
Function
|
Purpose
|
|---|---|
|
CURRENT_CATALOG()
|
Returns the current catalog
|
|
CURRENT_SCHEMA()
|
Returns the current schema
|
|
CURRENT_USERID()
|
Returns the current user id
|
|
DATABASE_ENCRYPTION_LEVEL()
|
Returns the encryption level of the database
0 - no encryption
1 - encrypted, the key is not protected (empty password)
2 - encrypted, the key is protected by a separate startup password
3 - encrypted, a custom encryption method is used
|
|
HOTSTANDBY_CONNECTSTATUS()
|
Returns status of connection between primary and secondary servers, see Using the HOTSTANDBY_CONNECTSTATUS function
|
|
HOTSTANDBY_ROLE()
|
Returns the HotStandby role of the server. For more information, see ADMIN COMMAND 'hsb role' in HOTSTANDBY.
|
|
HOTSTANDBY_STATE()
|
Returns the HotStandby state of the current server, see Using the HOTSTANDBY_STATE function
|
|
LOGIN_CATALOG()
|
Returns the login catalog
|
|
LOGIN_SCHEMA()
|
Returns the login schema
|
|
LOGIN_USERID()
|
Returns the login user ID
|
|
REPLICATION_STATUS(subscription-name)
|
Returns the replication status of the specified subscription
|
|
REPLICATION_QUEUE_LEN([subscription-name])
|
Returns number of transactions waiting to be processed by target database or, if subscription-name is included, returns the number of transactions from the specified source that are waiting to be processed
|
|
UIC()
|
Returns the connection id associated with the connection
|