<div>
Nevermind. &nbsp;Figured it out.. &nbsp;Its a VIEW.<br />
<br />
Moderator please delete.
</div>


Nevermind.  Figured it out..  Its a VIEW.

Moderator please delete.

<div>
In SQL Books online - Index tab<br />
type &quot;sysobjects system table&quot;<br />
press Enter &nbsp;and select &quot;sysobjects&quot;
</div>


In SQL Books online - Index tab
type "sysobjects system table"
press Enter  and select "sysobjects"

<div>
&gt;&gt;Moderator please delete.&lt;&lt;<br />
This is how it works:<br />
I answered my question myself. What do I do?<br />
<a href="https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi70" rel="ugc nofollow">https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi70</a>
</div>


>>Moderator please delete.<<
This is how it works:
I answered my question myself. What do I do?
https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi70 [https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi70]

<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I know a few of these already but does anyone know where I can find a document that describes what they following sysObjects.xtypes mean? &nbsp;If anything I'm most interested in the difference between U and V. &nbsp;U being a table but V is also a table thus the confusion.<br />
<br />
D &nbsp; - Field names<br />
F &nbsp; - Foreign Key<br />
FN - Function<br />
P &nbsp;- Stored Procedures<br />
PK - Primary Key<br />
S &nbsp;- System Tables<br />
U - User tables?<br />
V - Hidden tables?
</div>
</div>


Hi:

I know a few of these already but does anyone know where I can find a document that describes what they following sysObjects.xtypes mean?  If anything I'm most interested in the difference between U and V.  U being a table but V is also a table thus the confusion.

D   - Field names
F   - Foreign Key
FN - Function
P  - Stored Procedures
PK - Primary Key
S  - System Tables
U - User tables?
V - Hidden tables?

xType Definitions

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.