get_PrimaryKeys: Get primary keys from MySQL table

Description Usage Arguments Value

Description

Function will request table information from MySQL database information_schema.table_constraints table.

Usage

1
get_PrimaryKeys(tName, Group = "EPA_harshadb")

Arguments

tName

table name for which requesting primary keys

Group

Group name linked to my.cnf with connection information

Value

Returns a one column (COLUMN_NAME) data.table with primary key fields.


duanxd1/gfuns documentation built on March 7, 2020, 12:46 a.m.