Complete DDL statements support

[apstndb]

(Last updated of DDL statement list: 2024-10-27)

https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language

• SCHEMA statements Support named schema #100 Support SCHEMA DDL statements #179
  • CREATE SCHEMA
  • DROP SCHEMA
• DATABASE statements
  • CREATE DATABASE
  • ALTER DATABASE Implement ALTER DATABASE statement #161
• PLACEMENT statements Support CREATE PLACEMENT statement #165
  • CREATE PLACEMENT Implement CREATE PLACEMENT statement #194
• PROTO BUNDLE statements Support PROTO related syntax #89 Support DDLs for Protocol Buffers #176
  • CREATE PROTO BUNDLE
  • ALTER PROTO BUNDLE
  • DROP PROTO BUNDLE
• TABLE statements
  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • RENAME TABLE Support RENAME TABLE statement #130 Support RENAME TABLE statement #170
• INDEX statements
  • CREATE INDEX
  • ALTER INDEX
  • DROP INDEX
• SEARCH INDEX statements Support CREATE/ALTER/DROP SEARCH INDEX #108 Support full-text search DDLs #111
  • CREATE SEARCH INDEX
  • ALTER SEARCH INDEX
  • DROP SEARCH INDEX
• VIEW statements
  • CREATE VIEW and CREATE OR REPLACE VIEW
  • DROP VIEW Implement DROP VIEW statement #155
• CHANGE STREAM statements
  • CREATE CHANGE STREAM
  • ALTER CHANGE STREAM
  • DROP CHANGE STREAM
• ROLE statements
  • GRANT
  • REVOKE
• SEQUENCE statements
  • CREATE SEQUENCE
  • ALTER SEQUENCE
  • DROP SEQUENCE
• STATISTICS statements
  • ALTER STATISTICS Implement ALTER STATISTICS statement #163
  • ANALYZE Incompatibility: ANALYZE statement #93
• MODEL statements Incompatibility: CREATE/DROP/ALTER MODEL statements(a.k.a. Vertex AI integration) are not supported #96 Support MODEL DDL statements #195
  • CREATE MODEL and CREATE OR REPLACE MODEL
  • ALTER MODEL
  • DROP MODEL
• VECTOR INDEX statements
  • CREATE VECTOR INDEX
  • DROP VECTOR INDEX

https://cloud.google.com/spanner/docs/reference/standard-sql/graph-schema-statements

• PROPERTY GRAPH statements Support Spanner Graph #98 Support Spanner Graph(SQL/PGQ) schema statements #101
  • CREATE PROPERTY GRAPH
  • DROP PROPERTY GRAPH