Sysobjects Type and xtype

[jaylou]

Hi all,

I was checking indexes on a database and came across this object name
sysobjects.name = queue_messages_1977058079 sys.index.name = queue_clustered_index

Can anyone tell me what a type of "IT" is on an object in sysobjects? SQL Server 2005

Thanks,
Joe

 

[Jamfool]

http://msdn2.microsoft.com/en-us/library/ms190324.aspx

sys.objects (Transact-SQL)

IT = Internal table

 

[jaylou]

Thank you,
I guess they left that out of the local help in SQL2005.

Thank you again!