• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3238
  • Last Modified:

xType Definitions

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?
0
access_dude
Asked:
access_dude
1 Solution
 
access_dudeAuthor Commented:
Nevermind.  Figured it out..  Its a VIEW.

Moderator please delete.
0
 
ispalenyCommented:
V is view
0
 
ispalenyCommented:
In SQL Books online - Index tab
type "sysobjects system table"
press Enter  and select "sysobjects"
0
 
Anthony PerkinsCommented:
>>Moderator please delete.<<
This is how it works:
I answered my question myself. What do I do?
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi70
0
 
RomModCommented:
Comment from access_dude
Date: 08/27/2004 08:26AM PDT


Answer:

an xtype of V = View
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now