Monday, April 20

How to get underlying table information of a proxy table ?

How to check proxy table information ?

To know underlying server, database and table information of a proxy table we can
query sysattributes table from within local database.

The query can be as below.

select object_type, object_cinfo, char_value from sysattributes where object_type = 'OD'

OD stands for 'Object Definition' , no clue as of now why 'OD' though :( , will get it some where
down the line... no rush :)

0 comments:





Disclaimer :
Unless, otherwise mentioned, TF's SQL tips/tricks are for Sybase ASE 12.5.x