What is the system view for sys.syscolpars?

• keithy_sunny

  Mr or Mrs. 500

  Points: 566

  More actions

  December 15, 2016 at 11:07 pm

  #324059

  I am checking system base table at https://msdn.microsoft.com/en-us/library/ms179503.aspx and system internal views at https://technet.microsoft.com/en-us/library/ms189600(v=sql.105).aspx

  For base table sys.syscolpars, is there a corresponding system view for it so that I can access its data without loginning in DAC mode?

  Thanks

• Eirikur Eiriksson

  SSC Guru

  Points: 182911

  More actions

  December 15, 2016 at 11:24 pm

  #1918321

  keithy_sunny (12/15/2016)

  ---

  I am checking system base table at https://msdn.microsoft.com/en-us/library/ms179503.aspx and system internal views at https://technet.microsoft.com/en-us/library/ms189600(v=sql.105).aspx

  For base table sys.syscolpars, is there a corresponding system view for it so that I can access its data without loginning in DAC mode?

  Thanks

  Use sys.columns

  😎

• December 20, 2016 at 9:28 pm

  This was removed by the editor as SPAM