ODBC的保留字有哪些?
来源:asp之家 时间:2009-10-28 18:34:00
见下表:
序号 | 保留字 | 序号 | 保留字 | 序号 | 保留字 |
1 | ADD | 80 | ESCAPE | 159 | OR |
2 | ABSOLUTE | 81 | EXCEPT | 160 | ORDER |
3 | ACTION | 82 | EXCEPTION | 161 | OUTER |
4 | ADA | 83 | EXIT | 162 | OUTPUT |
5 | ADD | 84 | EXEC | 163 | PRIMARY |
6 | ALL | 85 | EXECUTE | 164 | OVERLAPS |
7 | ALLOCATE | 86 | EXISTS | 165 | PAD |
8 | ALTER | 87 | EXTERNAL | 166 | PARTIAL |
9 | AND | 88 | EXTRACT | 167 | PASCAL |
10 | ANY | 89 | FALSE | 168 | PO SITION |
11 | ARE | 90 | FETCH | 169 | PRECISION |
12 | AS | 91 | FIRST | 170 | PREPARE |
13 | ASC | 92 | FLOAT | 171 | PRESERVE |
14 | ASSERTION | 93 | FOR | 172 | PRIMARY |
15 | AT | 94 | FOREIGN | 173 | PRIOR |
16 | AUTHORIZATION | 95 | FORTRAN | 174 | PRIVILEGES |
17 | AVG | 96 | FOUND | 175 | PROCEDURE |
18 | BEGIN | 97 | FROM | 176 | PUBLIC |
19 | BETWEEN | 98 | FULL | 177 | READ |
20 | BIT | 99 | GET | 178 | REAL |
21 | BIT_LENGTH | 100 | GLOBAL | 179 | REFERENCES |
22 | BOTH | 101 | GO | 180 | RELATIVE |
23 | BY | 102 | GOTO | 181 | RESTRICT |
24 | CASCADE | 103 | GRANT | 182 | REVOKE |
25 | CASCADED | 104 | GROUP | 183 | RIGHT |
26 | CASE | 105 | HAVING | 184 | ROLLBACK |
27 | CAST | 106 | HOUR | 185 | ROWS |
28 | CATALOG | 107 | IDENTITY | 186 | SCHEMA |
29 | CHAR | 108 | IMMEDIATE | 187 | SCROLL |
30 | CHAR_LENGTH | 109 | IN | 188 | SECOND |
31 | CHARACTER | 110 | INCLUDE | 189 | SECTION |
32 | CHARACTER_LENGTHINNER | 111 | INDEX | 190 | SELECT |
33 | SIZE | 112 | INDICATOR | 191 | SESSION |
34 | CHECK | 113 | INITIALLY | 192 | SESSION_USER |
35 | CLOSE | 114 |
| 193 | SET |
36 | COALESCE | 115 | INTERSECT | 194 | SMALLINT |
37 | COLLATE | 116 | INPUT | 195 | SOME |
38 | COLLATION | 117 | INSENSITIVE | 196 | SPACE |
39 | COLUMN | 118 | INSERT | 197 | SQL |
40 | SQLCODE | 119 | INT | 198 | SQLCA |
41 | COMMIT | 120 | INTEGER | 199 | SQLERROR |
42 | CON NECT | 121 | INTO | 200 | SQLSTATE |
43 | CONNECTION | 122 | INTERVAL | 201 | SQLWARNING |
44 | CONSTRAINT | 123 | IS | 202 | SUM |
45 | CONSTRAINTS | 124 | ISOLATION | 203 | SYSTEM_USER |
46 | CONTINUE | 125 | SUBSTRING | 204 | TABLE |
47 | CONVERT | 126 | JOIN | 205 | TEMPORARY |
48 | CORRESPONDING | 127 | KEY | 206 | THEN |
49 | COUNT | 128 | LANGUAGE | 207 | TIME |
50 | CREATE | 129 | LAST | 208 | TIMESTAMP |
51 | CROSS | 130 | LEADING | 209 | TIMEZONE_HOUR |
52 | CURRENT | 131 | LEFT | 210 | TIMEZONE_MINUTE |
53 | CURRENT_DATE | 132 | LEVEL | 211 | TO |
54 | CURRENT_TIME | 133 | LIKE | 212 | TRAILING |
55 | CURRE NT_TIMESTAMP | 134 | LOCAL | 213 | TRANSACTION |
56 | CURRENT_USER | 135 | LOWER | 214 | TRANSLATE |
57 | CURSOR | 136 | MATCH | 215 | TRANSLATION |
58 | DATE | 137 | MAX | 216 | TRIM |
59 | DAY | 138 | MIN | 217 | TRUE |
60 | DEALLOCATE | 139 | MINUTE | 218 | UNION |
61 | DEC | 140 | MODULE | 219 | UNIQUE |
62 | DECIMAL | 141 | MONTH | 220 | UNKNOWN |
63 | DECLARE | 142 | NAMES | 221 | UPDATE |
64 | DEFAULT | 143 | NATIONAL | 222 | UPPER |
65 | DEFERRABLE | 144 | NATURAL | 223 | USAGE |
66 | DEFERRED | 145 | NCHAR | 224 | USER |
67 | DELETE | 146 | NEXT | 225 | USING |
68 | DESC | 147 | NO | 226 | VALUE |
69 | DESCRIBE | 148 | NONE | 227 | VALUES |
70 | DESCRIPTOR | 149 | NOT | 228 | VARCHAR |
71 | DIAGNOSTICS | 150 | NULL | 229 | VARYING |
72 | DISCONNECT | 151 | NULLIF | 230 | VIEW |
73 | DISTINCT | 152 | NUMERIC | 231 | WHENEVER |
74 | DOMAIN | 153 | OCTET_LENGTH | 232 | WHE RE |
75 | DOUBLE | 154 | OF | 233 | WITH |
76 | DROP | 155 | ONWHEN | 234 | WORK |
77 | ELSE | 156 | ONLY | 235 | WRITE |
78 | END | 157 | OPEN | 236 | YEAR |
79 | END- EXEC | 158 | OPTION | 237 | ZONE |