予約語 (SQL Server Compact Edition)

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) には、テーブル名や列名に使用できない予約語が存在します。

予約語の使用

SQL Server Compact Edition の予約語は、SQL Server 2005 の対応する予約語とは機能が異なる場合があります。次の表は、SQL Server Compact Edition の予約語の一覧です。

重要 :
予約語を識別子として使用しないでください。予約語を識別子として使用しなければならない場合は、二重引用符で区切る必要があります。

@@IDENTITY

ENCRYPTION

ORDER

ADD

END

OUTER

ALL

ERRLVL

OVER

ALTER

ESCAPE

PERCENT

AND

EXCEPT

PLAN

ANY

EXEC

PRECISION

AS

EXECUTE

PRIMARY

ASC

EXISTS

PRINT

AUTHORIZATION

EXIT

PROC

AVG

EXPRESSION

PROCEDURE

BACKUP

FETCH

PUBLIC

BEGIN

FILE

RAISERROR

BETWEEN

FILLFACTOR

READ

BREAK

FOR

READTEXT

BROWSE

FOREIGN

RECONFIGURE

BULK

FREETEXT

REFERENCES

BY

FREETEXTTABLE

REPLICATION

CASCADE

FROM

RESTORE

CASE

FULL

RESTRICT

CHECK

FUNCTION

RETURN

CHECKPOINT

GOTO

REVOKE

CLOSE

GRANT

RIGHT

CLUSTERED

GROUP

ROLLBACK

COALESCE

HAVING

ROWCOUNT

COLLATE

HOLDLOCK

ROWGUIDCOL

COLUMN

IDENTITY

RULE

COMMIT

IDENTITY_INSERT

SAVE

COMPUTE

IDENTITYCOL

SCHEMA

CONSTRAINT

IF

SELECT

CONTAINS

IN

SESSION_USER

CONTAINSTABLE

INDEX

SET

CONTINUE

INNER

SETUSER

CONVERT

INSERT

SHUTDOWN

COUNT

INTERSECT

SOME

CREATE

INTO

STATISTICS

CROSS

IS

SUM

CURRENT

JOIN

SYSTEM_USER

CURRENT_DATE

KEY

TABLE

CURRENT_TIME

KILL

TEXTSIZE

CURRENT_TIMESTAMP

LEFT

THEN

CURRENT_USER

LIKE

TO

CURSOR

LINENO

TOP

DATABASE

LOAD

TRAN

DATABASEPASSWORD

MAX

TRANSACTION

DATEADD

MIN

TRIGGER

DATEDIFF

NATIONAL

TRUNCATE

DATENAME

NOCHECK

TSEQUAL

DATEPART

NONCLUSTERED

UNION

DBCC

NOT

UNIQUE

DEALLOCATE

NULL

UPDATE

DECLARE

NULLIF

UPDATETEXT

DEFAULT

OF

USE

DELETE

OFF

USER

DENY

OFFSETS

VALUES

DESC

ON

VARYING

DISK

OPEN

VIEW

DISTINCT

OPENDATASOURCE

WAITFOR

DISTRIBUTED

OPENQUERY

WHEN

DOUBLE

OPENROWSET

WHERE

DROP

OPENXML

WHILE

DUMP

OPTION

WITH

ELSE

OR

WRITETEXT

参照

ヘルプおよび情報

SQL Server Compact Edition のサポートについて