TCustomMSConnection.Database Property

Used to specify the database name that is a default source of data for SQL queries once a connection is established.

Class

TCustomMSConnection

Syntax

property Database: string;

Remarks

Use the Database property to specify the database name that is a default source of data for SQL queries once a connection is established.

Altering the Database property makes new database name take effect immediately.

When Database is not assigned, SDAC 4.20 and higher will use the default database for the current SQL Server login specified in the TCustomDAConnection.Username property. Preceding SDAC versions use the 'master' database by default.

Setting Database='Northwind' allows you to omit database specifier in the SELECT statements. That is, instead of

SELECT * FROM Northwind..Products;

you may just write

SELECT * FROM Products

See Also

• TCustomDAConnection.Server
• TCustomDAConnection.Username
• TCustomDAConnection.Password