Send feedback
Stay organized with collections
Save and categorize content based on your preferences.
Version 3.18.0 keyboard_arrow_down
Table Admin
After creating an Database
, you can
interact with individual tables for that instance.
List Tables
To iterate over all existing tables for an database, use its
list_tables()
method:
for table in database.list_tables():
# `table` is a `Table` object.
This method yields Table
objects.
Table Factory
A Table
object can be created with the
table()
factory method:
table = database.table("my_table_id")
if table.exists():
print("Table with ID 'my_table' exists.")
else:
print("Table with ID 'my_table' does not exist."
Getting the Table Schema
Use the schema
property to inspect
the columns of a table as a list of
Field
objects.
for field in table.schema
# `field` is a `Field` object.
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-03-15 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?