|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > type and xtype for objects
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
type and xtype for objects
|
|
| Quentin Ran 2002-11-21, 10:24 am |
| Hi,
there are several system tables, e.g. sysobjects, where there are two
columns, type and xtype. What is the difference between these two columns?
Quentin
| |
| Peter Feakins 2002-11-21, 1:24 pm |
| To quote from an earlier post from BP Margolin:
"TYPE is included in sysobjects for backwards compatibility to earlier
versions of SQL Server.
XTYPE contains the current codes for the various possible database objects
recorded in the sysobjects table.
If you check the SQL Server Books Online documentation on the sysobjects
table, you will find, admittedly, minor differences between the values
supported by TYPE and XTYPE ..."
"Quentin Ran" <quentin.ran@gcserv.com> wrote in message
news:OFlVbZXkCHA.1368@tkmsftngp09...
> Hi,
>
> there are several system tables, e.g. sysobjects, where there are two
> columns, type and xtype. What is the difference between these two
columns?
>
> Quentin
>
>
|
|
|
|
|