DBD::Sybase supports the tables() method.
in reply to Re: DBI recipes
in thread DBI recipes
However, this relies on the existence of the sp_tables stored procedure, which I know exists in most recent versions of Sybase (i.e. 11.x and later), but I don't know if MSSQL has it.