using worksheets

Hi,

with a connection, with multiple databases (ie root user)

is it possible to set active database, when using worksheets. (instead of typing db_name.table_name for all queries)

Hi, you can set default database by right-click on database node in Object Explorer.

m.

thanks, but i actually mean, multiple worksheets open, each with its default db.

i already set a db as default, but for all other db worksheets,i need to type more =)

Only the worksheets associated with the active or current database do not require any additional information to be provided.