vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
|
|