Hi I'm playing with converting multiple databases to be combined into a singular database with each data being in a different schema. The quick question is:

Is it possible to make SQL select the table that belongs too the schema that it have logged into without having to prefix it with the schema name.

For example:

When logged in as user1 it would save us a lot of programming if you could just type:

select * from Atable;

rather than:

select * from user1.Atable;


The reason I think it might be possible is because if you have a simple database without mulitiple users it seems to let you off without define the schema.

Thanks Again Ed