保留字段

最近更新时间:2019-08-30 14:58:41

为了保证功能的正常使用和后续扩展,COS Select 功能制定了以下保留字段,包含函数名称、数据类型、运算符等字段。您在使用 SQL 查询语句时可能使用这些字段辅助您的查询。

序号 字段 序号 字段 序号 字段 序号 字段 序号 字段
1 absolute 51 create 101 goto 151 octet_length 201 struct
2 action 52 cross 102 grant 152 of 202 substring
3 add 53 current 103 group 153 on 203 sum
4 all 54 current_date 104 having 154 only 204 symbol
5 allocate 55 current_time 105 hour 155 open 205 system_user
6 alter 56 current_timestamp 106 identity 156 option 206 table
7 and 57 current_user 107 immediate 157 or 207 temporary
8 any 58 cursor 108 in 158 order 208 then
9 are 59 date 109 indicator 159 outer 209 time
10 as 60 day 110 initially 160 output 210 timestamp
11 asc 61 deallocate 111 inner 161 overlaps 211 timezone_hour
12 assertion 62 dec 112 input 162 pad 212 timezone_minute
13 at 63 decimal 113 insensitive 163 partial 213 to
14 authorization 64 declare 114 insert 164 pivot 214 trailing
15 avg 65 default 115 int 165 position 215 transaction
16 bag 66 deferrable 116 integer 166 precision 216 translate
17 begin 67 deferred 117 intersect 167 prepare 217 translation
18 between 68 delete 118 interval 168 preserve 218 trim
19 bit 69 desc 119 into 169 primary 219 true
20 bit_length 70 describe 120 is 170 prior 220 tuple
21 blob 71 descriptor 121 isolation 171 privileges 221 union
22 bool 72 diagnostics 122 join 172 procedure 222 unique
23 boolean 73 disconnect 123 key 173 public 223 unknown
24 both 74 distinct 124 language 174 read 224 unpivot
25 by 75 domain 125 last 175 real 225 update
26 cascade 76 double 126 leading 176 references 226 upper
27 cascaded 77 drop 127 left 177 relative 227 usage
28 case 78 else 128 level 178 restrict 228 user
29 cast 79 end 129 like 179 revoke 229 using
30 catalog 80 end-exec 130 limit 180 right 230 value
31 char 81 escape 131 list 181 rollback 231 values
32 char_length 82 except 132 local 182 rows 232 varchar
33 character 83 exception 133 lower 183 schema 233 varying
34 character_length 84 exec 134 match 184 scroll 234 view
35 check 85 execute 135 max 185 second 235 when
36 clob 86 exists 136 min 186 section 236 whenever
37 close 87 external 137 minute 187 select 237 where
38 coalesce 88 extract 138 missing 188 session 238 with
39 collate 89 false 139 module 189 session_user 239 work
40 collation 90 fetch 140 month 190 set 240 write
41 column 91 first 141 names 191 sexp 241 year
42 commit 92 float 142 national 192 size 242 zone
43 connect 93 for 143 natural 193 smallint - -
44 connection 94 foreign 144 nchar 194 some - -
45 constraint 95 found 145 next 195 space - -
46 constraints 96 from 146 no 196 sql - -
47 continue 97 full 147 not 197 sqlcode - -
48 convert 98 get 148 null 198 sqlerror - -
49 corresponding 99 global 149 nullif 199 sqlstate - -
50 count 100 go 150 numeric 200 string - -