"Andreas Klemt" <aklemt68@hotmail.com> wrote in message
news:%23NHH6H4zGHA.2072@TK2MSFTNGP06.phx.gbl...
> Hello,
>
> how can I list all indexs from a table?
> sp_indexes myTable
> does not work.
> Error message: Could not find server 'myTable' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
>
> Thanks for any help in advance!
>
> Regards
> Andreas Klemt
>

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OkiOmL4zGHA.4392@TK2MSFTNGP04.phx.gbl...
> Well, for starters, table_name is not the first parameter. But I think
> you're looking for sp_helpindex:
>
> EXEC sp_helpindex @objname = N'myTable';
>
>
>
> "Andreas Klemt" <aklemt68@hotmail.com> wrote in message
> news:%23NHH6H4zGHA.2072@TK2MSFTNGP06.phx.gbl...
>> Hello,
>>
>> how can I list all indexs from a table?
>> sp_indexes myTable
>> does not work.
>> Error message: Could not find server 'myTable' in sysservers. Execute
>> sp_addlinkedserver to add the server to sysservers.
>>
>> Thanks for any help in advance!
>>
>> Regards
>> Andreas Klemt
>>
>
>

> Well, for starters, table_name is not the first parameter. But I think
> you're looking for sp_helpindex:
>
> EXEC sp_helpindex @objname = N'myTable';
>
>
>
> "Andreas Klemt" <aklemt68@hotmail.com> wrote in message
> news:%23NHH6H4zGHA.2072@TK2MSFTNGP06.phx.gbl...
>> Hello,
>>
>> how can I list all indexs from a table?
>> sp_indexes myTable
>> does not work.
>> Error message: Could not find server 'myTable' in sysservers. Execute
>> sp_addlinkedserver to add the server to sysservers.
>>
>> Thanks for any help in advance!
>>
>> Regards
>> Andreas Klemt
>>
>
>