Stuart McLachlan
stuart at lexacorp.com.pg
Sun Sep 5 20:49:17 CDT 2004
On 5 Sep 2004 at 19:10, John W. Colby wrote:
> >SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid <
> 2
>
> When I did this, it didn't give an error but it returned 0 rows. What is
> indid?
>
Take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/tsqlref/ts_sys-i_76wj.asp
(That should be all one line)
--
Stuart