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

会计考友

　oracle的保留字 　　ACCESS ADD ALL ALTER AND ANY AS ASC AUDIT BETWEEN BY CHAR CHECK CLUSTER COLUMN COMMENT
* ^7 B* D9 h2 H. H" V" A　　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
5 {/ J: t" A$ k4 [3 h　　INSERT INTEGER INTERSECT INTO IS LEVEL LIKE LOCK LONG MAXEXTENTS MINUS MLSLABEL MODE MODIFY
　　NOAUDIT NOCOMPRESS NOT NOWAIT
. f' H* |7 x2 J% q: ]　　NULL NUMBER OF OFFLINE ON ONLINE OPTION OR ORDER PCTFREE PRIOR
　　PRIVILEGES PUBLIC RAW RENAME RESOURCE REVOKE ROW ROWID ROWNUM ROWS SELECT SESSION SET
$ ?4 W( Y- @+ f3 h9 \& u9 J　　SHARE SIZE SMALLINT START SUCCESSFUL SYNONYM SYSDATE TABLE THEN TO TRIGGER UID UNION UNIQUE
6 e; t6 F: i: P: S; Z- C& g" O　　UPDATE USER VALIDATE VALUES VARCHAR VARCHAR2 VIEW WHENEVER WHERE WITH
2 v4 Q* b. S5 h　　sql server的保留字
, g. _+ H$ y+ ~2 g4 x9 s0 T　　ADD EXCEPT PERCENT
! _: k! g( o% U, O5 L　　ALL EXEC PLAN
　　ALTER EXECUTE PRECISION
　　AND EXISTS PRIMARY
' b+ r: G* f2 ?: o　　ANY EXIT PRINT
　　AS FETCH PROC
　　ASC FILE PROCEDURE
2 T+ j% A2 @1 j7 D# f5 e, t　　AUTHORIZATION FILLFACTOR PUBLIC
　　BACKUP FOR RAISERROR
　　BEGIN FOREIGN READ
1 R$ P; k2 Y* M& ~9 S0 z9 n　　BETWEEN FREETEXT READTEXT
% c4 e, n' ]; q  y　　BREAK FREETEXTTABLE RECONFIGURE
& K) V* n8 Y! l9 v　　BROWSE FROM REFERENCES
( n( p7 O" j7 g　　BULK FULL REPLICATION
4 S7 ~6 R' k; {# l8 B+ R　　BY FUNCTION RESTORE
1 ]5 k$ ]# ]. ^' `# r　　CASCADE GOTO RESTRICT
　　CASE GRANT RETURN
　　CHECK GROUP REVOKECHECKPOINT HAVING RIGHT
　　CLOSE HOLDLOCK ROLLBACK
) Z# Z; x9 w/ Z" Q% R- H　　CLUSTERED IDENTITY ROWCOUNT
　　COALESCE IDENTITY_INSERT ROWGUIDCOL
　　COLLATE IDENTITYCOL RULE
; B" G* N" N6 Q; ]( p8 r
: \# ~; e- }3 y; P$ C　　COLUMN IF SAVE

会计考友

</p>　　COMMIT IN SCHEMA
　　COMPUTE INDEX SELECT
5 T9 P: l4 R- O# D* ?) i4 a　　CONSTRAINT INNER SESSION_USER
　　CONTAINS INSERT SET
　　CONTAINSTABLE INTERSECT SETUSER
　　CONTINUE INTO SHUTDOWN
　　CONVERT IS SOME
* J+ ~2 ?0 D4 f. A; x  R& I# z) R　　CREATE JOIN STATISTICS
8 C+ I" V! ]5 J5 _6 m0 j2 E2 ^　　CROSS KEY SYSTEM_USER
( C1 G, |( d* w; K- w8 O' H9 P- ^　　CURRENT KILL TABLE
　　CURRENT_DATE LEFT TEXTSIZE
　　CURRENT_TIME LIKE THEN
- y) ~8 y. N3 v; T$ Z　　CURRENT_TIMESTAMP LINENO TO
9 J5 L9 r6 N* t- Y　　CURRENT_USER LOAD TOP
0 f" _9 H- u2 f3 Z- _. O' Q: _　　CURSOR NATIONAL TRAN
- c- z% J3 A( x5 G$ j$ a2 A: g7 c, G6 B　　DATABASE NOCHECK TRANSACTION
4 {6 ?# M3 H# j9 u. T$ {' m　　DBCC NONCLUSTERED TRIGGER
6 G3 y% n: V1 r. X　　DEALLOCATE NOT TRUNCATE
5 j8 c$ W! f8 D3 T6 q. m# Z( Y1 S$ e" [　　DECLARE NULL TSEQUAL
8 k4 K/ |) F+ z, I1 t5 P5 L　　DEFAULT NULLIF UNION
　　DELETE OF UNIQUE
; p* z3 W  M( C3 u　　DENY OFF UPDATE
! [0 q1 e" j) P& }! f3 e( E- W3 U7 v2 Z　　DESC OFFSETS UPDATETEXT
$ S0 A+ \9 x* e. h4 l! ?! z　　DISK ON USE
$ ~$ O; y$ O$ c- O; n( R+ @　　DISTINCT OPEN USER
　　DISTRIBUTED OPENDATASOURCE VALUES
& Q  Q) {% P9 J+ j9 ~1 ~　　DOUBLE OPENQUERY VAR
　　DROP OPENROWSET VIEW
7 L( o; m5 ?- ?! U# ~　　DUMMY OPENXML WAITFOR
　　DUMP OPTION WHEN
  j8 p; ^/ [$ _4 @& d1 h7 W　　ELSE OR WHERE
0 N1 f2 p* c: L　　END ORDER WHILE
　　ERRLVL OUTER WITH
6 t3 Q/ O+ s* S! A　　ESCAPE OVER WRITETEXT