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 |
gaby_58
Starting Member
33 Posts |
Posted - 2014-01-17 : 11:49:00
|
Hi all, If we partition a particular table and that has a view associated with it, what will happen to the view?Thanks for any tipsRegards |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-01-24 : 18:09:35
|
The view acts on the table as always; no change. A partition is a physical storage concept; Views are a logical data concept. Changing the physical storage would not have an effect on the logical data.===============================================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961) |
|
|
|
|
|