September 30, 2010 at 7:09 am
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!
September 30, 2010 at 7:12 am
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
September 30, 2010 at 7:20 am
I thought it was a user defined Table Type...
September 30, 2010 at 7:29 am
Thank you both. I am glad to see it's not an obscure system table. I can rest in peace now!
Toni
September 30, 2010 at 8:59 am
you may need to tone the caffeine intake, who knows what else you will find :hehe:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply