how to get list of user defined tables in the specific database in sybase
I need to list the name of all tables in the specific database in sybase
and then filter these table name according some string in the name.
this gives current database but i cant specify specific database
select name from sysobjects where type = 'U'
this gives more than tables, it includes trigger and stored procedure
Select name from sysobjects
WHERE db_name()='pad_orr_db'
does any body know how to do it and also filter the name of tables by some
string in the name for example only the table with the SASSA in the name
be displayed?
thanks in advanced
No comments:
Post a Comment