表修饰符和表修饰符子句中可用的修饰符列表
以下是可以在 TABLE MODIFIER 和 TABLES MODIFIER 子句中指定的修饰符列表:图 1. 修改器列表
对于所有这些修饰符,以下是它们兼容的输出格式:
| 修饰符 | ASC | DEL | 定界 | IXF |
|---|---|---|---|---|
| ANYORDER | X | X | X | X |
| 二进制数 | X | |||
| Cdeanalyzef频率 | X | X | X | X |
| CHARDEL | X | |||
| COLDEL | X | |||
| DECPT | X | |||
| DECPLUSBLANK | X | X | ||
| delprioritychar | X | X | ||
| dumpfile | X | X | X | |
| 转储文件访问全部 | X | X | X | |
| FASTPARSE | X | X | X | |
| 强制 | X | |||
| 生成忽略 | X | X | X | X |
| 缺少 GENERATEDMISSING | X | X | X | X |
| 通用概述 (GENERATEDOVERRIDE) | X | X | X | X |
| 标识忽略 | X | X | X | X |
| 身份缺失 | X | X | X | X |
| 标识覆盖 | X | X | X | X |
| IMPLICITLYHIDDENINCLUDE | X | X | X | X |
| IMPLICITLYHIDDENMISSING | X | X | X | X |
| 隐式十进制 | X | X | ||
| 索引可用空间 | X | X | X | X |
| Keepblank | X | |||
| 最大分析大小 | X | X | X | X |
| nochardel | X | |||
| NOCHECK长度 | X | X | ||
| NOROWWARNINGS | X | X | X | X |
| 空字符 | X | |||
| 包十进制 | X | |||
| 可用空间 (PAGEFREESPACE) | X | X | X | X |
| periodignore | X | X | X | X |
| periodmissing | X | X | X | X |
| periodoverride | X | X | X | X |
| 行更改时间戳忽略 | X | X | X | X |
| 行更改时间 | X | X | X | X |
| 行更改时间戳记 | X | X | X | X |
SECLABELCHAR |
X | X | X | X |
| SECLABELNAME | X | X | X | X |
| STRIPLZEROS | X | |||
| STRIPTBLANK | X | |||
脱衣舞娘 |
X | |||
| 总面积 | X | X | X | X |
| transactionidignore | X | X | X | X |
| transactionidmissing | X | X | X | X |
| transactionidoverride | X | X | X | X |
| 使用缺省值 | X | X | X | X |
| usegraphiccodepage | X | X | ||
| 分区 | X |