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
2 g/ F& A* w* v# `3 H& t8 ]　　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
) C$ F6 z4 {4 V0 G8 j　　UPDATE USER VALIDATE VALUES VARCHAR VARCHAR2 VIEW WHENEVER WHERE WITH
' g7 }/ |9 d' z0 D　　sql server的保留字
　　ADD EXCEPT PERCENT
( [3 Z$ M$ F. t" i7 F0 ~　　ALL EXEC PLAN
　　ALTER EXECUTE PRECISION
　　AND EXISTS PRIMARY
$ k6 ?" l0 E8 P7 g2 N  ?# ~　　ANY EXIT PRINT
3 }! m* q/ |( T+ c$ d+ F( V0 q) q9 W# T　　AS FETCH PROC
　　ASC FILE PROCEDURE
　　AUTHORIZATION FILLFACTOR PUBLIC
　　BACKUP FOR RAISERROR
% }$ _$ a9 P/ p& {7 m" ^0 Y& L% r+ y　　BEGIN FOREIGN READ
5 V2 I+ ^: P6 i7 b　　BETWEEN FREETEXT READTEXT
2 ?/ [4 Z( f- v" a4 p; f　　BREAK FREETEXTTABLE RECONFIGURE
　　BROWSE FROM REFERENCES
　　BULK FULL REPLICATION
　　BY FUNCTION RESTORE
4 e3 [$ A! P) d% Y. X( U　　CASCADE GOTO RESTRICT
& U2 N4 x% ~) z6 E- f4 N5 o' i# U  x- K　　CASE GRANT RETURN
　　CHECK GROUP REVOKECHECKPOINT HAVING RIGHT
　　CLOSE HOLDLOCK ROLLBACK
$ ^5 a4 q# t- X% o) N" y　　CLUSTERED IDENTITY ROWCOUNT
/ Z$ ]9 A# m! Q; d; d8 y" N　　COALESCE IDENTITY_INSERT ROWGUIDCOL
& l- y& _* w1 N; s　　COLLATE IDENTITYCOL RULE
: T" |" Z) u' L- `
　　COLUMN IF SAVE

会计考友

</p>　　COMMIT IN SCHEMA
　　COMPUTE INDEX SELECT
　　CONSTRAINT INNER SESSION_USER
9 [# U/ e# H+ A6 w　　CONTAINS INSERT SET
　　CONTAINSTABLE INTERSECT SETUSER
　　CONTINUE INTO SHUTDOWN
( J2 t" K% R0 v7 M& }: \　　CONVERT IS SOME
4 a0 G& ]! m& R3 C1 [/ r　　CREATE JOIN STATISTICS
　　CROSS KEY SYSTEM_USER
, |7 T( t2 K0 Q& \. p6 W+ s( I　　CURRENT KILL TABLE
8 q1 L) ]. x! Z& L+ f  V. i　　CURRENT_DATE LEFT TEXTSIZE
7 V  q0 W) N) U, H; g" v+ V. F& S　　CURRENT_TIME LIKE THEN
- y! z5 I3 f7 p- ^. K# }　　CURRENT_TIMESTAMP LINENO TO
; Z# c9 W( |6 C　　CURRENT_USER LOAD TOP
　　CURSOR NATIONAL TRAN
　　DATABASE NOCHECK TRANSACTION
　　DBCC NONCLUSTERED TRIGGER
　　DEALLOCATE NOT TRUNCATE
　　DECLARE NULL TSEQUAL
　　DEFAULT NULLIF UNION
: |1 Q# p+ }% y2 G　　DELETE OF UNIQUE
2 D: J; s8 W' R3 ^; i8 P% r　　DENY OFF UPDATE
4 Z$ L) d# x" L　　DESC OFFSETS UPDATETEXT
　　DISK ON USE
% U7 B' Q/ Q6 D. n( D0 R　　DISTINCT OPEN USER
　　DISTRIBUTED OPENDATASOURCE VALUES
; k/ G6 I" r$ z' Y4 N! L　　DOUBLE OPENQUERY VAR
2 b$ K( d& u9 s　　DROP OPENROWSET VIEW
, s& P* k9 X- K& h4 C2 S　　DUMMY OPENXML WAITFOR
- R9 n3 g( y' A. p, q　　DUMP OPTION WHEN
% n7 `* _% U1 A1 V$ e# T　　ELSE OR WHERE
　　END ORDER WHILE
　　ERRLVL OUTER WITH
5 c$ T1 n$ V( M. l2 T4 S　　ESCAPE OVER WRITETEXT