DML Glossary

• B
• Between - The between keyword allows a query to retrieve data that falls within a given range.
• D
• Delete - Delete removes a document from a schema based on a given criteria.
• DML Glossary - A catalog of DML related topics.
• E
• Exec - Exec is used to execute a stored procedure (system or user created).
• G
• Group By - Group by allows you to select a result set and collapse it by a set of given fields.
• I
• Insert - Insert is used to create new documents in a database schema.
• L
• Like - Allows for basic pattern matching in a where clause.
• List - Lists the documents or schemas contained in a given schema.
• Logical Connectors - Connects one logical expression to another.
• N
• Not - The NOT keyword performs a not operation on logical operators such as LIKE and BETWEEN.
• O
• Order By - Order by allows you to sort a result-set by a given set of fields.
• S
• Sample - Returns a random sample of documents from a schema.
• Select - Select statements are used to read (or query) data from the database.
• System Procedures - Built in procedures that allow you to evaluate various aspect of the database engine.
• T
• Top - The top keywork limits the number of results that are returned by a query.
• Transaction - Transactions provide your queries with an "all or nothing" approach to data modifications.
• U
• Update - Update allows you to alter the data stored in a schema.
• W
• Where - The where clause allows you to add qualifiers to various types of queries.