Console
    Contact Us Start free

    DatabaseDetails

    Details of a logical database.

    JSON representation 
     { 
 "databaseName" 
 : 
 string 
 , 
 "parentDatabaseDeployment" 
 : 
 { 
 object (  ParentDatabaseDeployment 
 
) 
 } 
 , 
 "allocatedStorageBytes" 
 : 
 string 
 , 
 "schemas" 
 : 
 [ 
 { 
 object (  DatabaseSchema 
 
) 
 } 
 ] 
 }
    Fields
    databaseName

    string

    The name of the database.
    parentDatabaseDeployment

    object ( ParentDatabaseDeployment )

    The parent database deployment that contains the logical database.
    allocatedStorageBytes

    string ( int64 format)

    The allocated storage for the database in bytes.
    schemas[]

    object ( DatabaseSchema )

    The database schemas.

    ParentDatabaseDeployment

    The identifiers of the parent database deployment.

    JSON representation 
     { 
 "generatedId" 
 : 
 string 
 , 
 "manualUniqueId" 
 : 
 string 
 }
    Fields
    generatedId

    string

    The parent database deployment generated ID.
    manualUniqueId

    string

    The parent database deployment optional manual unique ID set by the user.

    DatabaseSchema

    Details of a database schema.

    JSON representation 
     { 
 "schemaName" 
 : 
 string 
 , 
 "tablesSizeBytes" 
 : 
 string 
 , 
 "objects" 
 : 
 [ 
 { 
 object (  DatabaseObjects 
 
) 
 } 
 ] 
 , 
 // Union field engine_details 
can be only one of the following: 
 "sqlServer" 
 : 
 { 
 object (  SqlServerSchemaDetails 
 
) 
 } 
 , 
 "mysql" 
 : 
 { 
 object (  MySqlSchemaDetails 
 
) 
 } 
 , 
 "postgresql" 
 : 
 { 
 object (  PostgreSqlSchemaDetails 
 
) 
 } 
 // End of list of possible types for union field engine_details 
. 
 }
    Fields
    schemaName

    string

    The name of the schema.

    tablesSizeBytes

    string ( int64 format)

    The total size of tables in bytes.

    objects[]

    object ( DatabaseObjects )

    List of details of objects by category.

    Union field engine_details . Engine-specific details. engine_details can be only one of the following:
    sqlServer

    object ( SqlServerSchemaDetails )

    Details of a SqlServer schema.

    mysql

    object ( MySqlSchemaDetails )

    Details of a Mysql schema.

    postgresql

    object ( PostgreSqlSchemaDetails )

    Details of a PostgreSql schema.

    DatabaseObjects

    Details of a group of database objects.

    JSON representation 
     { 
 "category" 
 : 
 enum (  Category 
 
) 
 , 
 "count" 
 : 
 string 
 }
    Fields
    category

    enum ( Category )

    The category of the objects.
    count

    string ( int64 format)

    The number of objects.

    Category

    The category of a database object.

    Enums
    CATEGORY_UNSPECIFIED Unspecified type.
    TABLE Table.
    INDEX Index.
    CONSTRAINTS Constraints.
    VIEWS Views.
    SOURCE_CODE Source code, e.g. procedures.
    OTHER Uncategorized objects.

    SqlServerSchemaDetails

    Specific details for a SqlServer database.

    JSON representation 
     { 
 "clrObjectCount" 
 : 
 integer 
 }
    Fields
    clrObjectCount

    integer

    Optional. SqlServer number of CLR objects.

    MySqlSchemaDetails

    Specific details for a Mysql database.

    JSON representation 
     { 
 "storageEngines" 
 : 
 [ 
 { 
 object (  MySqlStorageEngineDetails 
 
) 
 } 
 ] 
 }
    Fields
    storageEngines[]

    object ( MySqlStorageEngineDetails )

    Optional. Mysql storage engine tables.

    MySqlStorageEngineDetails

    Mysql storage engine tables.

    JSON representation 
     { 
 "engine" 
 : 
 enum (  Engine 
 
) 
 , 
 "tableCount" 
 : 
 integer 
 , 
 "encryptedTableCount" 
 : 
 integer 
 }
    Fields
    engine

    enum ( Engine )

    Required. The storage engine.
    tableCount

    integer

    Optional. The number of tables.
    encryptedTableCount

    integer

    Optional. The number of encrypted tables.

    Engine

    Storage engines.

    Enums
    ENGINE_UNSPECIFIED Unspecified storage engine.
    INNODB InnoDB.
    MYISAM MyISAM.
    MEMORY Memory.
    CSV CSV.
    ARCHIVE Archive.
    BLACKHOLE Blackhole.
    NDB NDB.
    MERGE Merge.
    FEDERATED Federated.
    EXAMPLE Example.
    OTHER Other.

    PostgreSqlSchemaDetails

    Specific details for a PostgreSql schema.

    JSON representation 
     { 
 "foreignTablesCount" 
 : 
 integer 
 , 
 "postgresqlExtensions" 
 : 
 [ 
 { 
 object (  PostgreSqlExtension 
 
) 
 } 
 ] 
 }
    Fields
    foreignTablesCount

    integer

    Optional. PostgreSql foreign tables.
    postgresqlExtensions[]

    object ( PostgreSqlExtension )

    Optional. PostgreSql extensions.

    PostgreSqlExtension

    PostgreSql extension.

    JSON representation 
     { 
 "extension" 
 : 
 string 
 , 
 "version" 
 : 
 string 
 }
    Fields
    extension

    string

    Required. The extension name.
    version

    string

    Required. The extension version.
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: