Contents Index sr_marker table sr_option table

SQL Remote User's Guide
  System Objects for Adaptive Server Enterprise
    SQL Remote system tables

sr_object table


Function 

Holds a list of SQL Remote objects. The extraction utility needs to know not to extract the SQL Remote system objects. The sp_populate_sql_anywhere procedure that creates a set of Adaptive Server Anywhere system tables in TEMPDB gets a list of SQL Remote objects from the sr_object table.

Columns 
Column Data type Description
name VARCHAR(128) The name of the object.
type CHAR(1) One of the following:
  • U    User-defined table

  • V    View

  • P    Procedure


Contents Index sr_marker table sr_option table