The following examples show how to reference remote tables using the foreign server prefix syntax. Example: Generate an execution plan Example: Select Rows from a Remote Table Example: Reference a Remote Table Using a Table Alias Example: Join a Local Table with a Remote Table. Example: Join Remote Tables through Different Foreign Servers Example: Create a View Using a Remote Table