What does table type of 'TT' in sys.objects mean ??

• toniupstny

  Hall of Fame

  Points: 3986

  More actions

  September 30, 2010 at 7:09 am

  #241035

  Ok... Probably a dumb question here from an overly-hyper person who will not rest easily till the result is known. Perhaps too much coffee.

  There is a type of 'TT' in sys.objects which says it is Table Type. What does that mean and when/where/what would it be set for?

  Thanks!

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  September 30, 2010 at 7:12 am

  #1229591

  http://msdn.microsoft.com/en-us/library/ms177596.aspx

  It should show you the tables you have in your database.

  Actually according to this: http://msdn.microsoft.com/en-us/library/bb522526.aspx It is used to define table-valued parameters for stored procedures.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton

• grahamc

  SSCertifiable

  Points: 6762

  More actions

  September 30, 2010 at 7:20 am

  #1229600

  I thought it was a user defined Table Type...

• toniupstny

  Hall of Fame

  Points: 3986

  More actions

  September 30, 2010 at 7:29 am

  #1229606

  Thank you both. I am glad to see it's not an obscure system table. I can rest in peace now!

  Toni

• grahamc

  SSCertifiable

  Points: 6762

  More actions

  September 30, 2010 at 8:59 am

  #1229681

  you may need to tone the caffeine intake, who knows what else you will find :hehe: