Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've seen alot of talk about source tables, and target tables on the internet, but no definitions of what these things are...from what I can infer it seems to mean something about copying data from an old table with an old schema into a new table with a new this what it means?

share|improve this question
It can mean that or any thing related, it can mean transferring data from oracle to sql server, or from production systems to your data warehouse. it can many all of that, the source table is the table which you will import your data from and the destination is the final location that your data will go to. read about Extract, transform and load (ETL) – AmmarR Aug 7 '12 at 7:00
up vote 5 down vote accepted

Essentially the source table is the place where the data is coming from and the target table is the place where the data is going to or the table that an action is taking place on. They do not have to be in different schema's or have a different structure to each other and in fact they could actually be the same table.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.