USE test SELECT * FROM sys.Tables order by name
SELECT * from sysobjects where [type] in ('U') and name like '%tablename%'
declare @sqlQuery varchar(500); select @sqlQuery=(case when 1=1 then 'select *from Test1.dbo.Testing' else 'select *from Test2.dbo.Testing' end) exec (@sqlQuery)
Select * from <dbname>.dbo.sysobjects where name = '<tablename>'
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'TABLE NAME'
.test.dbo.sp_tables 'testing'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)