Weird system view?

• thava

  SSCrazy

  Points: 2275

  More actions

  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]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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