Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
issammansour
Yak Posting Veteran
51 Posts |
 Posted - 2007-08-17 : 12:27:58
|
| Hi,My ERP System has sub-systems each system has separate tables. Is there any way to separate the tables on the same database container? If not way is the best way to keep the tables for each system separated from the others.Best regards |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-17 : 12:38:23
|
If using SQL Server 2005, you can use different schemas.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
issammansour
Yak Posting Veteran
51 Posts |
Posted - 2007-08-17 : 12:42:37
|
| yes we are using sql 2005, how |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-17 : 12:53:15
|
How can I explain it different from Books Online?In SQL Server 2000, you had an owner to each table, most often the "dbo".In SQL Server 2005, you can "prefix" every table with a "name" such as "Sales.Employee" and "HR.Employee".If I am not making myself clear enough, now is the time to read Books Online, your future best friend.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
issammansour
Yak Posting Veteran
51 Posts |
Posted - 2007-08-17 : 16:39:39
|
| thank you |
|
|
|
|
|
|
DataBase Tables