Query without having to specify table's schema
13
votes
5
answers
76298
views
I imported a bunch of tables from SQL Server 2000 to my 2008 database. All the imported tables are prefixed with my username eg:
erpadmin.tablename
.
In the table properties it lists 'erpadmin' as the db schema. When I write a query I now have to include 'erpadmin.' in front of all the table names which is confusing.
Current result:
select *
from erpadmin.tablename
Desired result:
select *
from tablename
Asked by Ramdas Bhosale
(231 rep)
May 24, 2013, 12:52 AM
Last activity: Feb 22, 2023, 07:55 AM
Last activity: Feb 22, 2023, 07:55 AM