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.
sp_tab_suspectptn [table_name]
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.
Any user can execute sp_tab_suspectptn. Permission checks do not differ based on the granular permissions settings.