FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Dan Harris [mailto:coronadh AT coronasolutions.com]
> Sent: May 28, 2002 1:53 PM
> 
> I'm using FTDS 0.53 talking to MSSQL 2000..  For some reason, 
> it seems that I 
> need to specifiy DATABASE.DBO.TABLENAME when doing SQL.. but 
> not all the time?  

The default database is an attribute of a login.  If your application uses
one account consistently, it will always land in the same default database.


You *can* use database.owner.tablename (or, usually, database..tablename)
anytime or all the time.  Many RDBMSs -- I don't know about postgresql --
don't have a notion of "a database" in the namespace, so I understand why
you'd want to avoid qualifying the table names.  

--jkl