//  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_LEVEL
PARENT_UNIQUE_NAME
PARTIAL
PASCAL
PASSWORD
PATH
PERCENT
PERIODSTODATE
PIVOT
PLAN
POSITION
POSTFIX
PRECISION
PREFIX
PREORDER
PREPARE
PRESERVE
PREVMEMBER
PRIMARY
PRINT
PRIOR
PRIVILEGES
PROC
PROCEDURE
PROPERTIES
PROPERTY
PUBLIC
Keyword: Q topSQLODBCJetAccessOLAPFuture SQL
QTD
QUERIES
QUERY
QUIT
Keyword: R topSQLODBCJetAccessOLAPFuture SQL
RAISERROR
RANK
READ
READS
READTEXT
REAL
RECALC
RECONFIGURE
RECORDSET
RECURSIVE
REF
REFERENCES
REFERENCING
REFRESH
REFRESHLINK
REGISTERDATABASE
RELATION
RELATIVE
REPAINT
REPAIRDATABASE
REPLICATION
REPORT
REPORTS
REQUERY
RESTORE
RESTRICT
RESULT
RETURN
RETURNS
REVOKE
RIGHT
ROLE
ROLLBACK
ROLLUP
ROUTINE
ROW
ROWCOUNT
ROWGUIDCOL
ROWS
RULE
Keyword: S topSQLODBCJetAccessOLAPFuture SQL
SAVE
SAVEPOINT
SCHEMA
SCHEMA_NAME
SCOPE
SCREEN
SCROLL
SEARCH
SECOND
SECTION
SECTIONS
SELECT
SELECTSCHEMA
SELECTSECURITY
SELF
SELF_AND_AFTER
SELF_AND_BEFORE
SELF_BEFORE_AFTER
SEQUENCE
SESSION
SESSION_USER
SET
SETFOCUS
SETOPTION
SETS
SETUSER
SHORT
SHUTDOWN
SINGLE
SIZE
SMALLINT
SOLVE_ORDER
SOME
SPACE
SPECIFIC
SPECIFICTYPE
SQL
SQLCA
SQLCODE
SQLERROR
SQLEXCEPTION
SQLSTATE
SQLWARNING
START
STATE
STATEMENT
STATIC
STATISTICS
STDEV
STDEVP
STRING
STRUCTURE
SUBSTRING
SUM
SYSTEM_USER
Keyword: T topSQLODBCJetAccessOLAPFuture SQL
TABLE
TABLEDEF
TABLEDEFS
TABLEID
TEMPORARY
TERMINATE
TEXT
TEXTSIZE
THAN
THEN
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TOGGLEDRILLSTATE
TOP
TOPCOUNT
TOPPERCENT
TOPSUM
TRAILING
TRAN
TRANSACTION
TRANSFORM
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TRUNCATE
TSEQUAL
TYPE
Keyword: U topSQLODBCJetAccessOLAPFuture SQL
UNDER
UNION
UNIQUE
UNIQUEIDENTIFIER
UNKNOWN
UNNEST
UPDATE
UPDATEIDENTITY
UPDATEOWNER
UPDATESECURITY
UPDATETEXT
UPPER
USAGE
USE
USER
USING
Keyword: V topSQLODBCJetAccessOLAPFuture SQL
VALUE
VALUES
VAR
VARBINARY
VARCHAR
VARIABLE
VARP
VARYING
VIEW
Keyword: W topSQLODBCJetAccessOLAPFuture SQL
WAITFOR
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WORK
WORKSPACE
WRITE
WRITETEXT
WTD
Keyword: X topSQLODBCJetAccessOLAPFuture SQL
XOR
Keyword: Y topSQLODBCJetAccessOLAPFuture SQL
YEAR
YES
YESNO
YTD
Keyword: Z topSQLODBCJetAccessOLAPFuture SQL
ZONE

Related Articles

Are there tools available for auditing changes to SQL Server data?
Can I create an index on a BIT column?
Can I have optional parameters to my stored procedures?
Can I implement an input mask in SQL Server?
Can I make SQL Server format dates and times for me?
Can I start IDENTITY values at a new seed?
Can SQL Server tell me which row was inserted most recently?
How can I learn more about undocumented SQL Server stored procedures?
How can I make my SQL queries case sensitive?
How do I audit changes to SQL Server data?
How do I connect to a non-default instance of SQL Server?
How do I connect to SQL Server on a port other than 1433?
How do I create a cross-tab (or "pivot") query?
How do I determine if a table exists in a SQL Server database?
How do I drop a SQL Server database?
How do I find all the available SQL Servers on my network?
How do I get a list of SQL Server tables and their row counts?
How do I get rid of Named Pipes / DBNMPNTW errors?
How do I get the correct date/time from the msdb.sysjob* tables?
How do I get the nth row in a SQL Server table?
How do I get the result of dynamic SQL into a variable?
How do I handle REPLACE() within an NTEXT column in SQL Server?
How do I hide system tables in SQL Server's Enterprise Manager?
How do I know which version of SQL Server I'm running?
How do I limit the number of rows returned in my resultset?
How do I load text or csv file data into SQL Server?
How do I manage changes in SQL Server objects?
How do I monitor SQL Server performance?
How do I prevent linked server errors?
How do I reclaim space in SQL Server?
How do I recover data from SQL Server's log files?
How do I search for special characters (e.g. %) in SQL Server?
How do I start SQL Server Agent from ASP?
How do I time my T-SQL code?
How do I upsize from Access to SQL Server?
How do I upsize my MSDE database to full-blown SQL Server 2000?
How do I use a variable in a TOP clause in SQL Server?
How do I use GETDATE() within a User-Defined Function (UDF)?
How should I store an IP address in SQL Server?
Schema: How do I find all the foreign keys in a database?
SQL Server & MSDE
What are the capacities of Access, SQL Server, and MSDE?
What are the main differences between Access and SQL Server?
What do I need to know about SQL Server 2000 SP4?
Where else can I learn about SQL Server?
Where is SP4 for SQL Server 2000?
Why am I having problems with SQL Server 2000 SP3 / SP3a?
Why can't I install SQL Server on Windows Server 2003?
Why can't I install SQL Server on Windows XP?
Why can't I use LIKE '%datepart%' queries?
Why do I get "Login failed for user '\'."?
Why do I get 'object could not be found' or 'invalid object name'?
Why do I get errors about master..spt_values?
Why do I get script errors in Enterprise Manager's 'taskpad' view?
Why do I get SQLSetConnectAttr Failed errors?
Why do I have problems with views after altering the base table?
Why does EM crash when I get an error in a stored procedure?
Why does Enterprise Manager return 'Invalid cursor state'?
Why does my DELETE query not work?
Why does sp_spaceused return inaccurate values?
Why is Enterprise Manager slow at expanding my database list?
Why is my app slow after upgrading from SQL Server 7 to 2000?
Why is tempdb full, and how can I prevent this from happening?
Why should I consider using an auxiliary calendar table?
Why should I consider using an auxiliary numbers table?

 

 


Created: 1/11/2001 | Last Updated: 7/18/2004 | broken links | helpful | not helpful | statistics
© Copyright 2006, UBR, Inc. All Rights Reserved. (51)

 

Copyright 1999-2006, All rights reserved.
Finding content
Finding content.  An error has occured...