Post reply

Weird system view?

  • January 17, 2012 at 7:01 am

    #266709

    when i search for something i accidentally i found this

    when i run this Query

    sp_helptext 'sys.objects'

    i found the following result

    CREATE VIEW sys.objects AS

    SELECT name, object_id, principal_id, schema_id, parent_object_id,

    type, type_desc, create_date, modify_date,

    is_ms_shipped, is_published, is_schema_published

    FROM sys.objects$

    is this one is a recursive view or else some kind of system view if so how it works i need some explanation here and also i want to know what is the purpose of the $ symbol here, hope i get assistance here, thanks in advance

    Every rule in a world of bits and bytes, can be bend or eventually be broken
    MyBlog About Common dialog control
    A Visualizer for viewing SqlCommand object script [/url]

  • January 17, 2012 at 7:19 am

    #1434594

    It's not recursive. sys.objects$ is some hidden internal view, I've looked for its definition but I've never been able to dig it out.

    The best I've been able to get (DAC connection to a copy of the system resource DB) is "There is no text for object 'sys.objects$'."

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply