Microsoft SQL Server [dbo].[MyTable] [schema1].[MyTable] [schema2].[MyTable] [schema3].[MyTable] I want to union them. For example: select * from [*].[MyTable] Can I do that?

Reputation: 210

How to union many tables with same name but different schema without dynamic sql?

Microsoft SQL Server

I want to union them. For example:

select * from [*].[MyTable]

Can I do that?

Upvotes: 0

Reputation: 93704

Something like this

select * from [dbo].[MyTable]
UNION
select * from [schema1].[MyTable]
UNION
select * from [schema2].[MyTable]
UNION
select * from [schema3].[MyTable]

Upvotes: 1