An Invantive UniversalSQL statement can retrieve or exchange data for many traditional and online platforms. Many platforms also support the use of DML (Data Manipulation Language) statements to change the data contained. On a few platforms you can execute DDL (Data Definition Language) statements to create new data structure or objects such as tables, procedures or sequences.
Popular Invantive UniversalSQL extensions are the synchronize statement to make sure multiple data sources contain the same data and the use statement to run SQL across multiple partitions.
An SQL statement can be any of the following:
- [[Select Statement]]
- [[Insert Statement (insertStatement)]]
- [[Update Statement (updateStatement)]]
- [[Delete Statement (deleteStatement)]]
- [[DDL Statement (ddlStatement)]]
- [[Set Statement (setStatement)]]
- [[Use Statement]]
- [[Transaction Statement (transactionStatement)]]
- [[Execute File Statement (executeFileStatement)]]
- [[Synchronize Statement (synchronizeStatement)]]
- [[Create or Replace View Statement (createOrReplaceViewStatement)]]
- [[Drop View Statement (dropViewStatement)]]