User Defined Table Type

• ramana3327

  SSCoach

  Points: 19722

  More actions

  June 4, 2014 at 1:04 pm

  #286268

  Hi All,

  I have a sp they declared tablevariable as Type.

  I am looking for the possibilities of creating Index on that user defined table type. I didn't see new Index option under that user defined table type.

• ramana3327

  SSCoach

  Points: 19722

  More actions

  June 4, 2014 at 1:28 pm

  #1718980

  Sorry my mistake.

  I find it from this link

  http://technet.microsoft.com/en-us/library/bb522526%28v=sql.105%29.aspx

  Thanks