Hi all,
This is a question out of curiosity mostly, but it does have a need for what I am trying to do.

I have a customer that uses Epicor for their ERP system. All of the data for the ERP in on an SQL Server and all of the tables in the ERP database are prefixed with "[erp]". So when I reference one of the table in c# the sql would look like this

Code:
SELECT * FROM [erp].[tableName]
However if I were to create a new table on the server (in a different database) the table uses the "[dbo]" prefix.

What is the difference with the [erp] and [dbo] prefixes and why does SQL server do this?

I have been tasked with creating a relatively large app that will pull data from 2 or 3 ERP tables and I will need to create a number of new tables in a different database on the same server. When I do work for this customer, I normally would use their VPN to RDP into a development machine on their network which allows direct access to their database. Because of the size of this project, we I've assigned a second developer to work on it. To allow parallel work on the app, I want to recreate 2 or 3 of the customers' ERP tables on our local SQL Server to do a bulk of the development locally, but when I create the tables locally, they have a [dbo] prefix instead of the [erp] prefix.

Any insight would be appreciated.
Thank
Kevin