ExternalKey table

The ExternalKey table allows you to retrieve the external key names defined for a table's primary key.

Tip
To use the ExternalKey table, you need to know the GUIDs of the tables you're working with. You can retrieve table GUIDs using the Table table.

This topic contains the following sections:

Requirements

When you write templates that access this table, follow these requirements:

Specify the Symbolic Name for the table version to use:
Copy
```
TableID = ExternalKey-1.0
```
Specify an Intent that this table supports:
- Retrieve
Retrieve templates: This table does not require the use of a fetcher. However, the following fetchers are available to optimize your query and are listed from most efficient to least:
TableId (Equals/In)
Copy
```
[Filter] 
TableId = Equals(Id1)          # You can filter on literals or variables from the [User] or [Calculated] section.
```
Copy
```
[Filter]                        
TableId = In(["Id1","Id2","Id3"])
```

ExternalKey column descriptions

This list includes each column's name, which you use in expressions to retrieve data, and data type, which defines how the data is retrieved.

Column	Data Type	Description
TableId	Id<Table>	The ID of the table.
SystemNames	Set<Text>	A comma-separated list of External Key System Names.