Sample Header Ad - 728x90

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