DML Glossary

DML: Data Manipulation Language

B D E G I L N O S T U W

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.