var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can I run a select statement w/o specifing the owners table name?
Can I run a select statement w/o specifing the owners table name?
How is it possible to run a select query without specifing the owners table name?
Query1: Select * from customers;
Query 2: Select * from user1.customers;
Now, when user1 or even user2 tries to open the Query1 I get the error that object 'customers' does not exist.
Last edited by AJV; 07-09-03 at 08:55.
You can run it with out the owner name, if you are logged in as the object owner. Otherwise, you have to specify it.
...unless the owner is dbo. If all your tables are dbo owned you don't need to specify the owner as dbo is assumed as default.