N and U in OBJECT_ID

• rshafer

  SSChasing Mays

  Points: 655

  More actions

  November 24, 2008 at 9:32 am

  #196209

  What does N and U stand for/do when using OBJECT_ID?

  IF OBJECT_ID(N'tempdb..#test', 'U') IS NOT NULL

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 24, 2008 at 9:53 am

  #902593

  rshafer (11/24/2008)

  ---

  What does N and U stand for/do when using OBJECT_ID?

  IF OBJECT_ID(N'tempdb..#test', 'U') IS NOT NULL

  This is a unicode (nvarchar) string: N'tempdb..#test'

  This, 'U', mean user defined table.

  You can find the different object types by looking up the sys.objects table in Books Online.