[Download] | [Documentation Home] | [Release Note]

Return Generated Keys

Introduction

"Return Generated Keys" feature can be used when inserting data to a table that has auto increment key column. This will map the auto incremented key value of that record to result output mappings in data service.

How to use Return Generated Keys

Following sample insert query is used to insert values to table called 'wes_teams' which has auto increment column.

Insert Query
Figure 01: Insert Query

Once click on Return Generated Keys it will add the auto increment key as output mapping.

Click Return Generated Keys
Figure 02: Click on Return Generated Keys