Thank you for the prompt reply...
I was not able to use the script as such, maybe version difference or something ... I'm using Sybase central 4.1. But, your suggestions gave me a starting point.
Just in case anyone else needs it ...
The Sybase equivalent of Oracle stmt
select * from user_tab_columns where column_name like 'xyz';
select * from syscolumns where cname='xyz'
The column tname from the result gives the table name