//  home   //  advanced search   //  news   //  categories   //  sql build chart   //  downloads   //  statistics
 ASP FAQ 
Home
ASP FAQ Tutorials

   8000XXXX Errors
   ASP.NET 2.0
   Classic ASP 1.0
   Databases
      Access DB & ADO
      General SQL Server & Access Articles
      MySQL
      Other Articles
      Schema Tutorials
      Sql Server 2000
      Sql Server 2005
   General Concepts
   Search Engine Optimization (SEO)

Contact Us
Site Map

Search

Web
aspfaq.com
tutorials.aspfaq.com
sqlserver2000.databases.aspfaq.com

ASP FAQ Tutorials :: Databases :: Sql Server 2000 :: What are reserved Access, ODBC and SQL Server keywords?


What are reserved Access, ODBC and SQL Server keywords?

The following table documents reserved keywords that should not be used as names for columns, tables, aliases, or other user-defined objects. If you are getting syntax errors of any kind, these are often due to using one of these reserved words.
Keyword: A  topSQLODBCJetAccessOLAPFuture SQL
ABSOLUTE
ACTION
ADA
ADD
ADMIN
ADMINDB
AFTER
AGGREGATE
ALIAS
ALL
ALLOCATE
ALPHANUMERIC
ALTER
ANCESTOR
AND
ANY
APPLICATION
ARE
ARRAY
AS
ASC
ASSERTION
ASSISTANT
AT
AUTHORIZATION
AUTOINCREMENT
AVG
AXIS
Keyword: B topSQLODBCJetAccessOLAPFuture SQL
BACK_COLOR
BACKUP
BAND
BASC
BDESC
BEFORE
BEFORE_AND_AFTER
BEGIN
BETWEEN
BINARY
BIT
BIT_LENGTH
BLOB
BNOT
BOOLEAN
BOR
BOTH
BOTTOMCOUNT
BOTTOMPERCENT
BOTTOMSUM
BREADTH
BREAK
BROWSE
BULK
BXOR
BY
BYTE
Keyword: C topSQLODBCJetAccessOLAPFuture SQL
CALL
CASCADE
CASCADED
CASE
CAST
CATALOG
CATALOG_NAME
CELL
CELL_ORDINAL
CHAPTERS
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CHECKPOINT
CHILDREN
CHILDREN_CARDINALITY
CLASS
CLOB
CLOSE
CLOSINGPERIOD
CLUSTERED
COALESCE
COALESCEEMPTY
COLLATE
COLLATION
COLUMN
COLUMNS
COMMIT
COMP
COMPACTDATABASE
COMPLETION
COMPRESSION
COMPUTE
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONSTRUCTOR
CONTAINER
CONTAINS
CONTAINSTABLE
CONTINUE
CONVERT
CORRELATION
CORRESPONDING
COUNT
COUNTER
COUSIN
COVARIANCE
CREATE
CREATEDATABASE
CREATEDB
CREATEFIELD
CREATEGROUP
CREATEINDEX
CREATEOBJECT
CREATEPROPERTY
CREATERELATION
CREATETABLEDEF
CREATEUSER
CREATEWORKSPACE
CROSS
CROSSJOIN
CUBE
CUBE_NAME
CURRENCY
CURRENT
CURRENT_DATE
CURRENT_PATH
CURRENT_ROLE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURRENTMEMBER
CURRENTUSER
CURSOR
CYCLE
Keyword: D topSQLODBCJetAccessOLAPFuture SQL
DATA
DATABASE
DATE
DATETIME
DAY
DBCC
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULTMEMBER
DEFERRABLE
DEFERRED
DELETE
DENY
DEPTH
DEREF
DESC
DESCENDANTS
DESCRIBE
DESCRIPTION
DESCRIPTOR
DESTROY
DESTRUCTOR
DETERMINISTIC
DIAGNOSTICS
DICTIONARY
DIMENSION
DIMENSION_UNIQUE_NAME
DISALLOW
DISCONNECT
DISK
DISTINCT
DISTINCTROW
DISTRIBUTED
DOCUMENT
DOMAIN
DOUBLE
DRILLDOWNLEVEL
DRILLDOWNLEVELBOTTOM
DRILLDOWNLEVELTO
DRILLDOWNMEMBER
DRILLDOWNMEMBERBOTTOM
DRILLDOWNMEMBERTOP
DRILLUPLEVEL
DRILLUPMEMBER
DROP
DUMMY
DUMP
DYNAMIC
Keyword: E topSQLODBCJetAccessOLAPFuture SQL
EACH
ECHO
ELSE
EMPTY
END
END-EXEC
EQUALS
EQV
ERRLVL
ERROR
ESCAPE
EVERY
EXCEPT
EXCEPTION
EXCLUSIVECONNECT
EXEC
EXECUTE
EXISTS
EXIT
EXTERNAL
EXTRACT
Keyword: F topSQLODBCJetAccessOLAPFuture SQL
FALSE
FETCH
FIELD
FIELDS
FILE
FILLCACHE
FILLFACTOR
FILTER
FIRST
FIRSTCHILD
FIRSTSIBLING
FLOAT
FLOAT4
FLOAT8
FONT_FLAGS
FONT_NAME
FONT_SIZE
FOR
FORE_COLOR
FOREIGN
FORM
FORMAT_STRING
FORMATTED_VALUE
FORMS
FORTRAN
FOUND
FREE
FREETEXT
FREETEXTTABLE
FROM
FULL
FULLTEXTTABLE
FUNCTION
Keyword: G topSQLODBCJetAccessOLAPFuture SQL
GENERAL
GENERATE
GET
GETOBJECT
GETOPTION
GLOBAL
GO
GOTO
GOTOPAGE
GRANT
GROUP
GROUP BY
GROUPING
GUID
Keyword: H topSQLODBCJetAccessOLAPFuture SQL
HAVING
HIERARCHIZE
HIERARCHY_UNIQUE_NAME
HOLDLOCK
HOST
HOUR
Keyword: I topSQLODBCJetAccessOLAPFuture SQL
IDENTITY
IDENTITY_INSERT
IDENTITYCOL
IDLE
IEEEDOUBLE
IEEESINGLE
IF
IGNORE
IIF
IMAGE
IMMEDIATE
IMP
IN
INCLUDE
INDEX
INDEXES
INDICATOR
INHERITABLE
INITIALIZE
INITIALLY
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INSERTTEXT
INT
INTEGER
INTEGER1
INTEGER2
INTEGER4
INTERSECT
INTERVAL
INTO
IS
ISEMPTY
ISOLATION
ITEM
ITERATE
Keyword: J topSQLODBCJetAccessOLAPFuture SQL
JOIN
Keyword: K topSQLODBCJetAccessOLAPFuture SQL
KEY
KILL
Keyword: L topSQLODBCJetAccessOLAPFuture SQL
LAG
LANGUAGE
LARGE
LAST
LASTCHILD
LASTMODIFIED
LASTPERIODS
LASTSIBLING
LATERAL
LEAD
LEADING
LEFT
LESS
LEVEL
LEVEL_UNIQUE_NAME
LEVELS
LIKE
LIMIT
LINENO
LINREGINTERCEPT
LINREGR2
LINREGSLOPE
LINREGVARIANCE
LOAD
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCATOR
LOGICAL
LOGICAL1
LONG
LONGBINARY
LONGCHAR
LONGTEXT
LOWER
Keyword: M topSQLODBCJetAccessOLAPFuture SQL
MACRO
MAP
MATCH
MAX
MEDIAN
MEMBER
MEMBER_CAPTION
MEMBER_GUID
MEMBER_NAME
MEMBER_ORDINAL
MEMBER_TYPE
MEMBER_UNIQUE_NAME
MEMBERS
MEMO
MIN
MINUTE
MOD
MODIFIES
MODIFY
MODULE
MONEY
MONTH
MOVE
MTD
Keyword: N topSQLODBCJetAccessOLAPFuture SQL
NAME
NAMES
NATIONAL
NATURAL
NCHAR
NCLOB
NEW
NEWPASSWORD
NEXT
NEXTMEMBER
NO
NOCHECK
NON
NONCLUSTERED
NONE
NOT
NOTE
NULL
NULLIF
NUMBER
NUMERIC
Keyword: O topSQLODBCJetAccessOLAPFuture SQL
OBJECT
OCTET_LENGTH
OF
OFF
OFFSETS
OLD
OLEOBJECT
ON
ONLY
OPEN
OPENDATASOURCE
OPENINGPERIOD
OPENQUERY
OPENRECORDSET
OPENROWSET
OPENXML
OPERATION
OPTION
OR
ORDER
ORDINALITY
ORIENTATION
OUT
OUTER
OUTPUT
OVER
OVERLAPS
OWNERACCESS
Keyword: P topSQLODBCJetAccessOLAPFuture SQL
PAD
PAGES
PARALLELPERIOD
PARAMETER
PARAMETERS
PARENT
PARENT_LEV