Getting all table names that match a WHERE mask

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Getting all table names that match a WHERE mask

Author

Topic

pug2694328
Posting Yak Master

166 Posts

Posted - 2006-02-02 : 12:24:07

What query would return a list of table names that match a mask?

Example: Get all tables with OPT in the name.

SELECT
*
FROM
?
WHERE
NAME LIKE '%OPT%'

nr
SQLTeam MVY

12543 Posts

Posted - 2006-02-02 : 12:25:37

SELECT
*
FROM
sysobjects
WHERE
NAME LIKE '%OPT%'
and xtype = 'U'

also see information_schema.tables

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.