GNOME Data Access 5 manual: gda-list-server-op-5.0

## gda-list-server-op-5.0

The gda-list-server-op-5.0 tool lists available DDL operations for one or all of the installed providers. For each type of operation (and each provider), the named parameters are also displayed. See the General words about DDL queries for more information about possible operations and usage. This tool has got several options, use the `--help` option to list them all.

For example listing all the possible operations (for all the providers) is:

    [prompt]> gda-list-server-op-5.0 -l
    Using XML descriptions in /usr/share/libgda-5.0
    Existing operation types:
    CREATE_DB
    DROP_DB
    CREATE_TABLE
    DROP_TABLE
    RENAME_TABLE
    ADD_COLUMN
    DROP_COLUMN
    CREATE_INDEX
    DROP_INDEX

Listing all the operations supported by the SQLite provider (notice that the SQLite provider does not support the DROP_COLUMN operation as SQLite does not support it):

    [prompt]> gda-list-server-op-5.0 -l -p SQLite
    Using XML descriptions in /usr/share/libgda-5.0
    For provider SQLite
    Existing operation types for provider 'SQLite':
    CREATE_DB
    DROP_DB
    CREATE_TABLE
    DROP_TABLE
    RENAME_TABLE
    ADD_COLUMN
    CREATE_INDEX
    DROP_INDEX

Listing all the possible parameters for the MySQL provider and for the DROP_COLUMN operation:

    [prompt]> gda-list-server-op-5.0 -o DROP_COLUMN -p MySQL
    Using XML descriptions in /usr/share/libgda-5.0
    For provider MySQL
    Description for type: DROP_COLUMN
    <?xml version="1.0"?>
    <server_op>
      <path id="/COLUMN_DESC_P" node_type="PARAMLIST" name="Column's description"/>
      <path id="/COLUMN_DESC_P/TABLE_NAME" node_type="PARAMETER" gdatype="gchararray" name="Table" descr="Table's name"/>
      <path id="/COLUMN_DESC_P/COLUMN_NAME" node_type="PARAMETER" gdatype="gchararray" name="Field name"/>
    </server_op>

Listing all the possible parameters for the all the installed providers and for the DROP_COLUMN operation:

    [prompt]> gda-list-server-op-5.0 -o DROP_COLUMN
    Using XML descriptions in /usr/share/libgda-5.0
    Description for type: DROP_COLUMN
    <?xml version="1.0"?>
    <server_op>
      <path id="/COLUMN_DESC_P" node_type="PARAMLIST">
        <prov prov_name="mysql" name="Column's description"/>
        <prov prov_name="postgres" name="Column's description"/>
      </path>
      <path id="/COLUMN_DESC_P/TABLE_NAME" node_type="PARAMETER" gdatype="gchararray">
        <prov prov_name="mysql" name="Table" descr="Table's name"/>
        <prov prov_name="postgres" name="Table" descr="Table's name"/>
      </path>
      <path id="/COLUMN_DESC_P/COLUMN_NAME" node_type="PARAMETER" gdatype="gchararray">
        <prov prov_name="mysql" name="Field name"/>
        <prov prov_name="postgres" name="Field name"/>
      </path>
      <path id="/COLUMN_DESC_P/REFERENCED_ACTION" node_type="PARAMETER" gdatype="gchararray">
        <prov prov_name="postgres" name="References" descr="What to do with references on the column to delete"/>
      </path>
    </server_op>