SQLkiwi (12/20/2010)
This is true (although table variables can also have a primary key and unique non-clustered indexes, albeit without statistical information).
Paul,
I know you know this - this is just be ensure that anyone else reading this is aware.
Just like any other table, a table variable can have one (and only one) clustered index on it. Paul implies that the UNIQUE index on table variables has to be non-clustered; actually one of them can be the clustered index on that table.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes