What does "Three and Four-part names? mean in "Elastic Query?

Ho Ming Tam 45 Reputation points
2024-02-18T15:06:42.2966667+00:00

as question, would you please advise?

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
15 questions
0 comments No comments
{count} votes

Accepted answer
  1. Marcin Policht 24,275 Reputation points MVP
    2024-02-18T15:14:50.6133333+00:00

    In the context of Azure SQL Database and the concept of "Elastic Query," the term "Three and Four-part names" refers to the naming conventions used for referencing objects (tables, views, etc.) across different databases in a federated database system.

    • Three-Part Name: A three-part name includes the name of the database, the schema, and the object name - for example DatabaseName.dbo.Employee
    • Four-Part Name: A four-part name extends the three-part name by including the server or data warehouse name - for example ServerName.DatabaseName.dbo.Employee

    In Elastic Query, which is part of Azure SQL Database, you can use three and four-part names to query data across multiple databases within the same logical server or even across different logical servers. This is achieved by setting up an elastic database query with the necessary credentials and configurations.


    hth
    Marcin

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.