close

Close DuckDB native interface database connection

Since R2026a

collapse all in page

    Syntax

    close(conn)

    Description

    close(conn) closes and invalidates the DuckDB native interface database connection to free up database and driver resources.

    example

    Examples

    collapse all

    Open Live Script

    Create a transient, in-memory DuckDB™ database connection by using the duckdb function.

    conn = duckdb()
    conn = 
  connection with properties:

                    Database: "memory"

  Database Properties:

                    ReadOnly: false
                  AutoCommit: "on"

  Catalog and Schema Information:

              DefaultCatalog: "memory"
                    Catalogs: "memory"
                     Schemas: "main"

  Database and Driver Information:

         DatabaseProductName: "DuckDB"
      DatabaseProductVersion: "v1.3.2"

    Verify that the connection is open by using the isopen function and confirm that the output is 1.

    isopen(conn)
    ans = logical
   1

    Close the connection by using the close function. Check that the connection is closed by using the isopen function and verify that the output is 0.

    close(conn);
isopen(conn)
    ans = logical
   0

    Input Arguments

    collapse all

    DuckDB native interface database connection, specified as a connection object.

    Version History

    Introduced in R2026a

    See Also

    |