Avatar of vpnsol123
vpnsol123
 asked on

SQL Query against multiple databases

I need to write a query, that will be used as a view to select all columns from the same named table in each of my databases into a single result panel.
SQLDatabases

Avatar of undefined
Last Comment
vpnsol123

8/22/2022 - Mon
JesterToo

If this is Sql Server then you can use multi-part names that are capable of referencing objects from different schemas, different databases and even different servers.

See this link for more info...   https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql
vpnsol123

ASKER
Thank you for the above.  What I am looking to do is to write a single query the will read the database names out of the sys_databases table and run the query against each of them.  Sorry, that was not clear at all in my initial post.
ASKER CERTIFIED SOLUTION
JesterToo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
vpnsol123

ASKER
thanks
Your help has saved me hundreds of hours of internet surfing.
fblack61