找不到帮助的来看:jetsql保留字
来源:优易学  2011-12-9 16:55:55   【优易学:中国教育考试门户网】   资料下载   IT书店
 SQL 保留字
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
  下表包括了所有 Microsoft Jet 数据库引擎保留的用于 SQL 语句的字。列表中的字,若不是全部大写,也被其它应用程序所保留。因此,对于这些字的各个帮助主题只提供了通常的描述,并未着重 SQL的用法。

  --------------------------------------------------------------------------------

  注意 跟着一星号 * 的词是被保留的,但是当前在 Microsoft® Jet SQL 语句的范畴内并没有意义(例如,Level 和 TableID)。未加下划线的字没有链接的解释。

  --------------------------------------------------------------------------------

  A

  ABSOLUTE ANY
  ADD ARE
  ADMINDB AS
  ALL ASC
  Alphanumeric — See TEXT ASSERTION
  ALTER AUTHORIZATION
  ALTER TABLE AUTOINCREMENT — See COUNTER
  And Avg
  AS

  B-C

  BEGIN COLLATION
  Between COLUMN
  BINARY COMMIT
  BIT COMP, COMPRESSION
  BIT_LENGTH CONNECT
  BOOLEAN — See BIT CONNECTION
  BOTH CONSTRAINT, CONSTRAINTS
  BY CONTAINER
  BYTE CONTAINS
  CASCADE CONVERT
  CATALOG Count
  CHAR, CHARACTER — See TEXT COUNTER
  CHAR_LENGTH CREATE
  CHARACTER_LENGTH CURRENCY
  CHECK CURRENT_DATE
  CLOSE CURRENT_TIME
  CLUSTERED CURRENT_TIMESTAMP
  COALESCE CURRENT_USER
  COLLATE CURSOR

  D

  DATABASE DISALLOW
  DATE — See DATETIME DISCONNECT
  DATETIME DISTINCT
  DAY DISTINCTROW
  DEC, DECIMAL DOMAIN
  DECLARE DOUBLE
  DELETE DROP
  DESC

  E-H

  Eqv FOREIGN
  EXCLUSIVECONNECT FROM
  EXEC, EXECUTE FROM 子句
  EXISTS GENERAL — See LONGBINARY
  EXTRACT GRANT
  FALSE GROUP
  FETCH GUID
  FIRST HAVING
  FLOAT,FLOAT8 — 参阅 DOUBLE HOUR
  FLOAT4 — See SINGLE

  I

  IDENTITY INPUT
  IEEEDOUBLE — See DOUBLE INSENSITIVE
  IEEESINGLE — See SINGLE INSERT
  IGNORE INSERT INTO
  IMAGE INT,INTEGER,INTEGER4 — 参阅 LONG
  Imp INTEGER1 — 参阅 BYTE
  In INTEGER2 — 参阅 SHORT
  IN INTERVAL
  INDEX INTO
  INDEXCREATEDB Is
  INNER ISOLATION

  J-M

  JOIN LONGTEXT
  KEY LOWER
  LANGUAGE MATCH
  LAST Max
  LEFT MEMO — 参阅 LONGTEXT
  Level* Min
  Like MINUTE
  LOGICAL,LOGICAL1 — 参阅 BIT Mod
  LONG MONEY — 参阅 CURRENCY
  LONGBINARY MONTH
  LONGCHAR

  N-P

  NATIONAL Outer*
  NCHAR OUTPUT
  NONCLUSTERED OWNERaccess
  Not PAD
  NTEXT PARAMETERS
  NULL PARTIAL
  NUMBER — See DOUBLE PASSWORD
  NUMERIC — See DECIMAL PERCENT
  NVARCHAR PIVOT
  OCTET_LENGTH POSITION
  OLEOBJECT — See LONGBINARY PRECISION
  ON PREPARE
  OPEN PRIMARY
  OPTION PRIVILEGES
  Or PROC, PROCEDURE
  ORDER PUBLIC

 Q-S

  REAL — See SINGLE SMALLDATETIME
  REFERENCES SMALLINT — See SHORT
  RESTRICT SMALLMONEY
  REVOKE SOME
  RIGHT SPACE
  ROLLBACK SQL
  SCHEMA SQLCODE, SQLERROR, SQLSTATE
  SECOND StDev
  SELECT StDevP
  SELECTSCHEMA STRING — See TEXT
  SELECTSECURITY SUBSTRING
  SET Sum
  SHORT SYSNAME
  SINGLE SYSTEM_USER
  SIZE

  T-Z

  TABLE UPDATEOWNER
  TableID* UPDATESECURITY
  TEMPORARY UPPER
  TEXT USAGE
  TIME — See DATETIME USER
  TIMESTAMP USING
  TIMEZONE_HOUR VALUE
  TIMEZONE_MINUTE VALUES
  TINYINT Var
  TO VARBINARY — 参阅 BINARY
  TOP VARCHAR — 参阅 TEXT
  TRAILING VarP
  TRANSACTION VARYING
  TRANSFORM VIEW
  TRANSLATE WHEN
  TRANSLATION WHENEVER
  TRIM WHERE
  TRUE WITH
  UNION WORK
  UNIQUE Xor
  UNIQUEIDENTIFIER YEAR
  UNKNOWN YESNO — See BIT
  UPDATE ZONE
  UPDATEIDENTITY

责任编辑:小草

文章搜索:
 相关文章
热点资讯
资讯快报
热门课程培训