cakephp / phinx

     * @param string $tableName Table Name

     * @return array

     */

    public function getPrimaryKey($tableName)

    {

        $rows = $this->fetchAll(sprintf(

            "SELECT

                k.constraint_name,

                k.column_name

            FROM information_schema.table_constraints t

            JOIN information_schema.key_column_usage k

                USING(constraint_name,table_name)

            WHERE t.constraint_type='PRIMARY KEY'

                AND t.table_name='%s'",

            $tableName

        ));

        $primaryKey = [

            'columns' => [],

        ];

        foreach ($rows as $row) {

            $primaryKey['constraint'] = $row['constraint_name'];

            $primaryKey['columns'][] = $row['column_name'];

        }

        return $primaryKey;

    }

    /**

     * @param string $tableName Table Name

     * @return array

     */

    public function getPrimaryKey($tableName)

    {

        $rows = $this->fetchAll(sprintf(

            "SELECT

                    tc.constraint_name,

                    kcu.column_name

                FROM information_schema.table_constraints AS tc

                JOIN information_schema.key_column_usage AS kcu

                    ON tc.constraint_name = kcu.constraint_name

                WHERE constraint_type = 'PRIMARY KEY'

                    AND tc.table_name = '%s'

                ORDER BY kcu.ordinal_position",

            $tableName

        ));

        $primaryKey = [

            'columns' => [],

        ];

        foreach ($rows as $row) {

            $primaryKey['constraint'] = $row['constraint_name'];

            $primaryKey['columns'][] = $row['column_name'];

        }

        return $primaryKey;

    }

    /**