GetDatabaseProperty method

Returns the value of the specified database property.

Syntax 
Visual Basic
Public Function GetDatabaseProperty( _
   ByVal name As String _
) As String
C#
public string  GetDatabaseProperty(
   string  name
);
Parameters

  • name   The name of the database property whose value you want to obtain. Property names are case insensitive.

Return value

The value of the property as a string.

Remarks

Recognized properties are:

Property

Description
CaseSensitive

The status of the case sensitivity feature. Returns ON if the database is case sensitive. Otherwise, it returns OFF.

Database case sensitivity affects how indexes on tables and result sets are sorted.

Case sensitivity does not affect how a connection's ULConnectionParms.UserID and ULConnectionParms.Password are verified. User IDs are always case insensitive and passwords are always case sensitive.

CharSet The character set of the database.
ChecksumLevel The level of database page checksums enabled for the database.
Collation The name of the database's collation sequence.
CollationName This property has been deprecated. Use "Collation" instead.
ConnCount The number of connections to the database.
date_format

The date format used for string conversions by the database.

This format is not necessarily the same as the one used by System.DateTime.
date_order The date order used for string conversions by the database.
Encryption The type of encryption applied to the database. Returns None, Simple, AES, or AES_FIPS.
File The file name of the database.
global_database_id The value of the global_database_id option used for global autoincrement columns.
isolation_level

The value of the isolation_level option used for controlling the degree to which the operations in one transaction are visible to the operations in other concurrent transactions.

This value is set on a per connection basis.
MaxHashSize The default maximum number of bytes to use for index hashing. This property can be set on a per-index basis.
ml_remote_id The value of the ml_remote_id option used for identifying the database during synchronization.
Name The name of the database (DBN).
nearest_century The nearest century used for string conversions by the database.
PageSize The page size of the database, in bytes.
precision The floating-point precision used for string conversions by the database.
scale The minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION during string conversions by the database.
time_format

The time format used for string conversions by the database.

This format is not necessarily the same as the one used by System.TimeSpan.
timestamp_format

The timestamp format used for string conversions by the database.

This format is not necessarily the same as the one used by System.DateTime.
timestamp_increment The minimum difference between two unique timestamp values, in microseconds (1,000,000th of a second).
See also
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1