sp_tab_suspectptn

Lists tables with suspect partitions. A range-partitioned table on character-based partition keys can become suspect after a sort-order change, and hash-partitioned tables can become suspect after a cross-platform dump load.

Syntax

sp_tab_suspectptn [table_name]

Parameters

Usage

If you:
  • Provide a table name – the SAP ASE server checks only the table named by table_name.

  • Do not provide a table name – the SAP ASE server checks all the tables in the current database.

Permissions

Any user can execute sp_tab_suspectptn. Permission checks do not differ based on the granular permissions settings.

Related reference
sp_indsuspect