getSchemaInfoSQL method

String getSchemaInfoSQL(
  1. TSchemaType schemaType,
  2. String schemaObjectName,
  3. String schemaPattern
)

Implementation

String getSchemaInfoSQL(
    TSchemaType schemaType, String schemaObjectName, String schemaPattern) {
  switch (schemaType) {
    case TSchemaType.stTables:
      return "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'";
    case TSchemaType.stColumns:
      return 'SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=${quotedStr(schemaObjectName)}';
    case TSchemaType.stProcedures:
      return 'SELECT *, ROUTINE_NAME AS PROCEDURE_NAME FROM INFORMATION_SCHEMA.ROUTINES';
    case TSchemaType.stSchemata:
      return 'SELECT * FROM INFORMATION_SCHEMA.SCHEMATA';
    case TSchemaType.stSequences:
      return 'SELECT * FROM INFORMATION_SCHEMA.SEQUENCES';
    default:
      databaseError(SMetadataUnavailable);
  }
}