JDBC create table
Stay organized with collections
Save and categorize content based on your preferences.
Create a table by using JDBC.
Explore further
For detailed documentation that includes this code sample, see the following:
Code sample
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],[],[],[],null,["# JDBC create table\n\nCreate a table by using JDBC.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Connect JDBC to a GoogleSQL-dialect database](/spanner/docs/use-oss-jdbc)\n\nCode sample\n-----------\n\n### Java\n\n\nTo learn how to install and use the client library for Spanner, see\n[Spanner client libraries](/spanner/docs/reference/libraries).\n\n\nTo authenticate to Spanner, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n import java.sql.Connection;\n import java.sql.DriverManager;\n import java.sql.SQLException;\n import java.sql.Statement;\n\n class CreateTableExample {\n\n static void createTable() throws SQLException {\n // TODO(developer): Replace these variables before running the sample.\n String projectId = \"my-project\";\n String instanceId = \"my-instance\";\n String databaseId = \"my-database\";\n createTable(projectId, instanceId, databaseId);\n }\n\n static void createTable(String projectId, String instanceId, String databaseId)\n throws SQLException {\n String connectionUrl =\n String.format(\n \"jdbc:cloudspanner:/projects/%s/instances/%s/databases/%s\",\n projectId, instanceId, databaseId);\n try (Connection connection = DriverManager.getConnection(connectionUrl)) {\n try (Statement statement = connection.createStatement()) {\n statement.execute(\n \"CREATE TABLE Singers (\\n\"\n + \" SingerId INT64 NOT NULL,\\n\"\n + \" FirstName STRING(1024),\\n\"\n + \" LastName STRING(1024),\\n\"\n + \" SingerInfo BYTES(MAX),\\n\"\n + \" Revenues NUMERIC,\\n\"\n + \") PRIMARY KEY (SingerId)\\n\");\n }\n }\n System.out.println(\"Created table [Singers]\");\n }\n }\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=spanner)."]]
