<div>
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.<br />
<br />
See this link for more info... &nbsp; <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql" rel="ugc">https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql</a>
</div>


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 [https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql]

<div>
Thank you for the above. &nbsp;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. &nbsp;Sorry, that was not clear at all in my initial post.
</div>


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.

<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

SQL Query against multiple databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.