萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Access 教學 >> Access 基礎教學

Access SQL 保留字完整對照表:避開欄位命名陷阱

撰寫 Access SQL 時,若欄位/資料表名稱與 Jet/ACE 引擎保留字衝突,會噴出「FROM 子句語法錯誤」等難解錯誤。解決方法:以方括號 `[]` 包裹識別碼,如 SELECT * FROM [User] WHERE [UserName]='...'。

常見高風險保留字 (開發者易踩雷)

  • User, Name, Date, Time, Key, Index, Order, Group, Level, Table, Password, Description, Type, Status, Value, Number, Text, Memo, Currency, Binary, Long, Short, Single, Double, Integer, Byte, Boolean, Logical, Counter, AutoIncrement, Identity, Primary, Foreign, Reference, Constraint, Default, Null, Not, And, Or, Between, Like, In, Is, Select, Insert, Update, Delete, Create, Drop, Alter, Join, Inner, Left, Right, Outer, Full, Cross, Union, Distinct, Top, Percent, Pivot, Transform, Parameters, Procedure, View, Schema, Domain, Catalog, Character, Numeric, Float, Real, Money, SmallInt, BigInt, TinyInt, Bit, Unique, Check, References, On, Cascade, Set, Option, Module, Function, Sub, Property, Event, Declare, Dim, ReDim, Static, Public, Private, Friend, Protected, Const, Enum, Type, Class, Interface, Implements, Inherits, MustOverride, NotOverridable, Overridable, Overrides, Shadows, Shared, ReadOnly, WriteOnly, WithEvents, Handles, RaiseEvent, AddHandler, RemoveHandler, Try, Catch, Finally, Throw, Using, SyncLock, Lock, Monitor, Thread, Task, Async, Await, Yield, Iterator, Anonymous, Lambda, Delegate, Event, Delegate, MulticastDelegate, Action, Func, Predicate, Expression, Linq, Query, Where, Select, GroupBy, OrderBy, Join, GroupJoin, SelectMany, Aggregate, Average, Count, Sum, Min, Max, Any, All, Contains, First, Last, Single, DefaultIfEmpty, Distinct, Union, Intersect, Except, Concat, Zip, Skip, Take, While, SkipWhile, TakeWhile, Reverse, OrderBy, ThenBy, OrderByDescending, ThenByDescending, GroupBy, Select, Where, Join, GroupJoin, SelectMany, Aggregate

完整保留字清單 (依字母分組,含同義字對照):

A: ADD, ALL, ALPHANUMERIC (見 TEXT), ALTER, AND, ANY, AS, ASC, AUTOINCREMENT (見 COUNTER), AVG
B-C: BETWEEN, BINARY, BIT, BOOLEAN (見 BIT), BY, BYTE, CHAR/CHARACTER (見 TEXT), COLUMN, CONSTRAINT, COUNT, COUNTER, CREATE, CURRENCY
D: DATABASE, DATE (見 DATETIME), DATETIME, DELETE, DESC, DISALLOW, DISTINCT, DISTINCTROW, DOUBLE, DROP
E-H: EQV, EXISTS, FLOAT/FLOAT8 (見 DOUBLE), FLOAT4 (見 SINGLE), FOREIGN, FROM, GENERAL (見 LONGBINARY), GROUP, GUID, HAVING
I: IEEEDOUBLE (見 DOUBLE), IEEESINGLE (見 SINGLE), IGNORE, IMP, IN, INDEX, INNER, INSERT, INT/INTEGER/INTEGER4 (見 LONG), INTEGER1 (見 BYTE), INTEGER2 (見 SHORT), INTO, IS
J-M: JOIN, KEY, LEFT, LEVEL*, LIKE, LOGICAL/LOGICAL1 (見 BIT), LONG, LONGBINARY, LONGTEXT, MAX, MEMO (見 LONGTEXT), MIN, MOD, MONEY (見 CURRENCY)
N-P: NOT, NULL, NUMBER (見 DOUBLE), NUMERIC (見 DOUBLE), OLEOBJECT (見 LONGBINARY), ON, OPTION, OR, ORDER, OUTER*, OWNERACCESS, PARAMETERS, PERCENT, PIVOT, PRIMARY, PROCEDURE
Q-S: REAL (見 SINGLE), REFERENCES, RIGHT, SELECT, SET, SHORT, SINGLE, SMALLINT (見 SHORT), SOME, STDEV, STDEVP, STRING (見 TEXT), SUM
T-Z: TABLE, TABLEID*, TEXT, TIME (見 DATETIME), TIMESTAMP (見 DATETIME), TOP, TRANSFORM, UNION, UNIQUE, UPDATE, VALUE, VALUES, VAR, VARBINARY (見 BINARY)

附註:標 * 者為保留但目前 Jet SQL 無語意 (如 LEVEL, TABLEID, OUTER)。

關鍵字:SQL、保留字、Jet、ACE、命名衝突、方括號逸脫

copyright © 萬盛學電腦網 all rights reserved