JDBC Driver for Google Sheets

Build 20.0.7587

Procedures

You can use the DatabaseMetaData interface to retrieve stored procedure information. The getProcedures method returns descriptions of the available stored procedures.

The following code retrieves the names of the available stored procedures:

String connectionString = "jdbc:googlesheets:InitiateOAuth=GETANDREFRESH;Spreadsheet=NorthwindOrders";

Connection conn = DriverManager.getConnection(connectionString);
DatabaseMetaData meta = conn.getMetaData();
ResultSet rs = meta.getProcedures(null, null, "%");
while(rs.next()){
  System.out.println(rs.getString("PROCEDURE_NAME"));
}
The getProcedures method returns the following columns:

Column NameData TypeDescription
PROCEDURE_CATStringThe catalog the procedure belongs to.
PROCEDURE_SCHEMStringThe schema the procedure belongs to.
PROCEDURE_NAMEStringThe stored procedure name.
REMARKSStringThe description of the stored procedure.
PROCEDURE_TYPEshortReturns 2 if the procedure returns a result. Returns 1 if the procedure does not return a result. Returns 0 if unknown.
SPECIFIC_NAMEStringThe name that uniquely identifies the stored procedure within its schema.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587