OffOn
    Register
    HomeSybase

    Sybase Error – CREATE/DROP STATISTICS statement cannot refer to virtual tables

    admin November 20, 2024 No Comments

    In this blog post, you’ll learn more about the Sybase Error CREATE/DROP STATISTICS statement cannot refer to virtual tables and the reason for receiving this error

    Sybase SQL Error Message

    CREATE/DROP STATISTICS statement cannot refer to virtual tables

    Reason for this Error

    You attempted to use CREATE/DROP STATISTICS to create/drop one or more histograms on a virtual database object, such as a view or remote table. The CREATE STATISTICS and DROP STATISTICS statements can only refer to base tables, local temporary tables, or global temporary tables in the SQL Anywhere database that you are connected to.

    Tag:

    Share:

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    You May Also Like

    See more

    Sybase Error – Seek failed: the requested segment offset %2 is outside the offset range of the file %3. %1

    In this blog post, you’ll learn more about the Sybase Error Seek failed: the requested segment offset %2 is outside...
    Read more

    Sybase Error – No indicator variable provided for NULL result

    In this blog post, you’ll learn more about the Sybase Error No indicator variable provided for NULL result and the...
    Read more

    Sybase Error – %2: Memory & disk block number mismatch; buffer={%3} page={%4}. %1

    In this blog post, you’ll learn more about the Sybase Error %2: Memory & disk block number mismatch; buffer={%3} page={%4}....
    Read more