| theintrepidfox@hotmail.com 2005-08-26, 1:23 pm |
|
Hi Group
It's a rainy day and because of pure boredom have right-clicked a row
in EM and selected 'Properties'.
Just being curious what the dialog coming up is all about (call me
ignorant!) and where I can find more information (Keyword?)in BOL?
One thing I wonder however and maybe someone can answer this question
is that this dialog suggests that a table is nothing more than a query
and not a physical representation of data? I'm not an SQL expert and
thought data is stored in 'pages' and that those pages are the actual
tables? I got this idea as on the 'Query' tab, the table name is listed
as 'Query Name'.
However, if it's a query, I should be able to just type the table name
in Query Analyzer (like calling a system sp) and execution should
return the table data which it doesn't but says it's a table object?
But then again, the table object must be based on a query?
Just wondered.
Thanks for your thoughts!
Martin
|