How I get the Primary Key name from a table?

Classic Servoy
1

Hallo

How I get the Primary Key name from a table?

For example:

var _fs = databaseManager.getFoundSet(MyDB, _tableArray[i])
_fs.loadAllRecords()

var _PkName = _fs.getPkName()

Is that possible somehow?

Regards
ttmgybta

2 
var vTable = databaseManager.getTable(_fs);
var vPkColumnNames = vTable.getRowIdentifierColumnNames();

should do.

3

Tanks, it works!

Should search a bit longer the next time in the servoy wiki :?

4

No. That’s what the forum is for.

5

Browsing the Solution Explorer window also helps ;)