# GetTablesAndKeys Method

## Overloads

| [GetTablesAndKeys(Size, Size, Int32, Boolean, Boolean, Boolean)](https://help.qlik.com/en-US/sense-developer/May2026/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IApp.GetTablesAndKeys.htm#Qlik_Engine_IApp_GetTablesAndKeys_Qlik_Engine_Size_Qlik_Engine_Size_System_Int32_System_Boolean_System_Boolean_System_Boolean_) |  | Returns:<br><br>\* The list of tables in an app and the fields inside each table.<br><br>\* The list of derived fields.<br><br>\* The list of key fields. |
| --- | --- | --- |

[](https://help.qlik.com/en-US/sense-developer/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IApp.GetTablesAndKeys.htm) [](https://help.qlik.com/en-US/sense-developer/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IApp.GetTablesAndKeys.htm)

## GetTablesAndKeys(Size, Size, Int32, Boolean, Boolean, Boolean)

Returns:

* The list of tables in an app and the fields inside each table.
* The list of derived fields.
* The list of key fields.

### Declaration

```

          GetTablesAndKeysResult GetTablesAndKeys([QixName("qWindowSize")] Size windowSize, [QixName("qNullSize")] Size nullSize, [QixName("qCellHeight")] int cellHeight, [QixName("qSyntheticMode")] bool syntheticMode, [QixName("qIncludeSysVars")] bool includeSysVars, [QixName("qIncludeProfiling")] bool includeProfiling = false)
    
  
```

### Parameters

| Type | Name | Description |
| --- | --- | --- |
| [Size](https://help.qlik.com/en-US/sense-developer/May2026/Subsystems/NetSDKAPIref/Content/Qlik.Engine.Size.htm) | windowSize | Size of the window that is used to display the results. |
| [Size](https://help.qlik.com/en-US/sense-developer/May2026/Subsystems/NetSDKAPIref/Content/Qlik.Engine.Size.htm) | nullSize |  |
| System.Int32 | cellHeight | Height of a cell in a table in pixels. |
| System.Boolean | syntheticMode | One of:<br><br><ul> <li> <code>true</code> for internal table viewer:Shows a more detailed view on how the Qlik engine defines the relations between fields and the quality of the keys.</li> <li> <code>false</code> for source table viewer:Shows the natural relation between fields without reference to synthetic keys and resultant linking synthetic tables. Instead synthetic keys are represented by multiple connectors between tables.</li> </ul> |
| System.Boolean | includeSysVars | If set to true, the system variables are included. |
| System.Boolean | includeProfiling | If set to true, profiling information is included. |

### Returns

| Type | Description |
| --- | --- |
| [GetTablesAndKeysResult](https://help.qlik.com/en-US/sense-developer/May2026/Subsystems/NetSDKAPIref/Content/Qlik.Engine.GetTablesAndKeysResult.htm) |  |