Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - .NET Programming » UltraLite .NET 1.0 API Reference » ULDatabaseSchema class

TableCount property Next Page

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
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.

CollationName

The name of the database's collation sequence.

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.

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 timestamps, in nanoseconds (1,000,000th of a second).

Exceptions
See also