Database Thing Shape Services
The following services are found on the database Thing Shape (PTC.DBConnection.Database_TS). These services perform actions on the database. All database Things, such as PTC.DBConnection.SQLThingDatabase, must implement this Thing Shape. If you create a new database Thing, ensure that this Thing Shape is implemented.
• AddColumn—Adds a column to a database table.
• AddForeignKey—Adds a foreign key to a database table.
• CreateIndex—Creates an index on a column in a database table.
• CreateTable—Creates a database table using the specified Data Shape.
• CreateTables—Creates database tables using the specified dbInfo input.
• Delete—Deletes data from the database for the specified Data Shape and UID.
• DropTable—Drops the table for the specified Data Shape from the database.
• DropTables—Drops database tables using the specified dbInfo input.
• Insert—Inserts data into the database table for the specified Data Shape.
• Query—Queries the database for the specified Data Shape. A filter can be applied with an offset and limit to narrow the list of returned results. For more information, see
Using JSON Filters in Query Services.
• Remove—Removes data from the database table for the specified Data Shape.
• RemoveColumn—Removes a column from a database table.
• RemoveForeignKey—Removes a foreign key from a database table.
• RemoveIndex—Removes an index from a column in a database table.
• Update—Updates data in a database table for the specified Data Shape.
• UpdateColumn—Updates a column in a database table.
• UpdateDatabaseSchema—Synchronizes the schema defined in the database with the specified dbInfo input for the Data Shape.
• ValidateDatabaseSchema—Validates the schema defined in the database against the specified dbInfo input.