The common syntax parts used in SQL syntax is described in this section.
| Part | Description |
|---|---|
| account_name | Name of the D3 account where the D3 file or q-pointer exists. The name must begin with a letter. Any combination of letters, numbers, and the underscore (_) can follow the initial letter. |
| table_name | Name of the table. The name may or may not be the same as the D3 file which it corresponds to because of SQL naming conventions and nested tables. The name must begin with a letter. Any combination of letters, numbers, and the underscore (_) can follow the initial letter. |
| column_name | Name of the column. The name may or may not be the same as the D3 file which it corresponds to because of SQL naming conventions and nested tables. The name must begin with a letter. Any combination of letters, numbers, and the underscore (_) can follow the initial letter. |
| default_value | Constant default value which is later used by INSERT statements to compute the default value for the desired column if none is explicitly indicated in the INSERT statement itself. |
| index_name | User-defined name of an index being created or deleted. The name must begin with a letter. Any combination of letters, numbers, and the underscore (_) can follow the initial letter. |
| length | Integer n (1 <= n <= 254). |
| precision | Integer p (1 <= p <= 15). |
| scale | Integer s (0 <= s <=p). |
| modulo_number | Integer corresponding to the classic D3 modulo for the internal file to be created. New users may find it easier to specify the file size in bytes. |
| size_in_bytes | Integer corresponding to the total maximum size of rows (combined) in the table in bytes. The number may be post-fixed with an M to indicate megabytes or K to indicate kilobytes. |