sys.sp_indexes
general #stored-procedure
Description
Returns index information for the specified remote table.
Syntax
sp_indexes
[ @table_server = ]
N
'table_server'
[ , [ @table_name = ]
N
'table_name'
]
[ , [ @table_schema = ]
N
'table_schema'
]
[ , [ @table_catalog = ]
N
'table_catalog'
]
[ , [ @index_name = ]
N
'index_name'
]
[ , [ @is_unique = ] is_unique ]
[ ; ]