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
 General SQL Server Forums
 New to SQL Server Programming
 Search to locate a table in SQL

Author  Topic 

wsilage
Yak Posting Veteran

82 Posts

Posted - 2014-09-22 : 10:36:45
Hi,

Is there a query that I can run in SQL to find all the table names? I have a certain table I am trying to locate.

Thanks

wsilage
Yak Posting Veteran

82 Posts

Posted - 2014-09-22 : 10:58:45
I found this....

SELECT * FROM INFORMATION_SCHEMA.TABLES
where TABLE_NAME like '%revenue'
order by TABLE_NAME
Go to Top of Page
   

- Advertisement -