current database name 1

[vionca]

Hi there,

I've been searching through the Books online and have found nothing so far. I was wondering if there was a built in function that would return the name of the database I was currently working in.

I was hoping to do something like
SELECT amtOverDue, databasename
FROM customer_tbl

Anyone have any ideas?

Vionca

 

[hmckillop]

SELECT amtOverDue, db_name()
FROM customer_tbl

 

[hmckillop]

forgot to mention, normally you pass through the id to this metadata function, but if none is passed it defaults to current database.