Drop Table

Drop tables from Airport-attached databases using standard SQL DROP TABLE statements with Arrow Flight server authorization.

The Airport extension supports dropping tables through standard SQL DROP TABLE statements. The Arrow Flight server determines whether to permit the table deletion.

Example

To drop a table, execute a standard SQL DROP TABLE statement referencing a schema managed by the Airport extension.

-- Attach an Airport database
ATTACH 'example' (TYPE AIRPORT, location 'grpc://localhost:50312/');

DROP TABLE example.main.employees;

Arrow Flight Server Implementation Notes

The Airport extension will perform a DoAction Arrow Flight RPC with a method name of drop_table.