会计考友 发表于 2012-8-4 13:54:49

Oracle辅导:oracle和sqlserver的系统保留关键字列表

 oracle的保留字   ACCESS ADD ALL ALTER AND ANY AS ASC AUDIT BETWEEN BY CHAR CHECK CLUSTER COLUMN COMMENT
  COMPRESS CONNECT CREATE CURRENT DATE DECIMAL DEFAULT DELETE DESC DISTINCT DROP ELSE EXCLUSIVE
  EXISTS FILE FLOAT FOR FROM GRANT GROUP HAVING IDENTIFIED IMMEDIATE IN INCREMENT INDEX INITIAL
  INSERT INTEGER INTERSECT INTO IS LEVEL LIKE LOCK LONG MAXEXTENTS MINUS MLSLABEL MODE MODIFY
  NOAUDIT NOCOMPRESS NOT NOWAIT
  NULL NUMBER OF OFFLINE ON ONLINE OPTION OR ORDER PCTFREE PRIOR
  PRIVILEGES PUBLIC RAW RENAME RESOURCE REVOKE ROW ROWID ROWNUM ROWS SELECT SESSION SET
  SHARE SIZE SMALLINT START SUCCESSFUL SYNONYM SYSDATE TABLE THEN TO TRIGGER UID UNION UNIQUE
  UPDATE USER VALIDATE VALUES VARCHAR VARCHAR2 VIEW WHENEVER WHERE WITH
  sql server的保留字
  ADD EXCEPT PERCENT
  ALL EXEC PLAN
  ALTER EXECUTE PRECISION
  AND EXISTS PRIMARY
  ANY EXIT PRINT
  AS FETCH PROC
  ASC FILE PROCEDURE
  AUTHORIZATION FILLFACTOR PUBLIC
  BACKUP FOR RAISERROR
  BEGIN FOREIGN READ
  BETWEEN FREETEXT READTEXT
  BREAK FREETEXTTABLE RECONFIGURE
  BROWSE FROM REFERENCES
  BULK FULL REPLICATION
  BY FUNCTION RESTORE
  CASCADE GOTO RESTRICT
  CASE GRANT RETURN
  CHECK GROUP REVOKECHECKPOINT HAVING RIGHT
  CLOSE HOLDLOCK ROLLBACK
  CLUSTERED IDENTITY ROWCOUNT
  COALESCE IDENTITY_INSERT ROWGUIDCOL
  COLLATE IDENTITYCOL RULE

  COLUMN IF SAVE

会计考友 发表于 2012-8-4 13:54:50

Oracle辅导:oracle和sqlserver的系统保留关键字列表

</p>  COMMIT IN SCHEMA
  COMPUTE INDEX SELECT
  CONSTRAINT INNER SESSION_USER
  CONTAINS INSERT SET
  CONTAINSTABLE INTERSECT SETUSER
  CONTINUE INTO SHUTDOWN
  CONVERT IS SOME
  CREATE JOIN STATISTICS
  CROSS KEY SYSTEM_USER
  CURRENT KILL TABLE
  CURRENT_DATE LEFT TEXTSIZE
  CURRENT_TIME LIKE THEN
  CURRENT_TIMESTAMP LINENO TO
  CURRENT_USER LOAD TOP
  CURSOR NATIONAL TRAN
  DATABASE NOCHECK TRANSACTION
  DBCC NONCLUSTERED TRIGGER
  DEALLOCATE NOT TRUNCATE
  DECLARE NULL TSEQUAL
  DEFAULT NULLIF UNION
  DELETE OF UNIQUE
  DENY OFF UPDATE
  DESC OFFSETS UPDATETEXT
  DISK ON USE
  DISTINCT OPEN USER
  DISTRIBUTED OPENDATASOURCE VALUES
  DOUBLE OPENQUERY VAR
  DROP OPENROWSET VIEW
  DUMMY OPENXML WAITFOR
  DUMP OPTION WHEN
  ELSE OR WHERE
  END ORDER WHILE
  ERRLVL OUTER WITH
  ESCAPE OVER WRITETEXT
页: [1]
查看完整版本: Oracle辅导:oracle和sqlserver的系统保留关键字列表