Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Indexes on table variable

Status
Not open for further replies.
MarnickBolle

MarnickBolle

Programmer
Feb 7, 2003
17
BE
Can you create indexes on fields of table variables like you can do for real tables?
 
Sort by date Sort by votes
In short, no. You can create them on temp tables though.

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
227
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
342
BobSuruncle
BobSuruncle
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
165
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
196
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
154
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top