<div class="meta" robots="noindex">

</div>

Method

# ODBCDatabase.SpecialColumns

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

<div class="warning">

<div class="title">

Warning

</div>

This item was deprecated in version 2021r2. Please use `ODBCDatabase.TableSpecialColumns<odbcdatabase.tablespecialcolumns>` as a replacement.

</div>

## Description

Retrieves the optimal set of columns that uniquely identifies a row in the table and columns that are automatically updated when any value in the row is updated by a transaction. Returns a `Recordset</api/deprecated/recordset>`.