The Wayback Machine - http://web.archive.org/web/20140109003800/http://msdn.microsoft.com:80/zh-tw/library/ms181249(v=sql.90).aspx

Developer Network

匯出 (0) 列印

全部展開

MSDN Library

伺服器和企業開發

SQL Server

SQL Server 2005

產品文件

SQL Server 2005 文件

SQL Server 2005 線上叢書

SQL Server 語言參考

Transact-SQL 參考

Transact-SQL 語法慣例 (Transact-SQL)

Transact-SQL 新功能和增強功能 (Transact-SQL)

+ (加) (Transact-SQL)

+ (一元加號) (Transact-SQL)

+ (字串串連) (Transact-SQL)

- (負號) (Transact-SQL)

- (減) (Transact-SQL)

* (乘法) (Transact-SQL)

/ (除法) (Transact-SQL)

% (模除) (Transact-SQL)

% (萬用字元 - 相符的字元) (Transact-SQL)

& (位元 AND) (Transact-SQL)

| (位元 OR) (Transact-SQL)

^ (位元互斥 OR) (Transact-SQL)

~ (位元 NOT) (Transact-SQL)

= (等於) (Transact-SQL)

> (大於) (Transact-SQL)

< (小於) (Transact-SQL)

>= (大於或等於) (Transact-SQL)

<= (小於或等於) (Transact-SQL)

<> (不等於) (Transact-SQL)

!< (不小於) (Transact-SQL)

!= (不等於) (Transact-SQL)

!> (不大於) (Transact-SQL)

-- (註解) (Transact-SQL)

/*...*/ (註解) (Transact-SQL)

[ ] (萬用字元 - 相符的字元) (Transact-SQL)

[^] (萬用字元 - 不相符的字元) (Transact-SQL)

_ (萬用字元 - 符合一個字元) (Transact-SQL)

$PARTITION (Transact-SQL)

@@CONNECTIONS (Transact-SQL)

@@CPU_BUSY (Transact-SQL)

@@CURSOR_ROWS (Transact-SQL)

@@DATEFIRST (Transact-SQL)

@@DBTS (Transact-SQL)

@@ERROR (Transact-SQL)

@@FETCH_STATUS (Transact-SQL)

@@IDENTITY (Transact-SQL)

@@IDLE (Transact-SQL)

@@IO_BUSY (Transact-SQL)

@@LANGID (Transact-SQL)

@@LANGUAGE (Transact-SQL)

@@LOCK_TIMEOUT (Transact-SQL)

@@MAX_CONNECTIONS (Transact-SQL)

@@MAX_PRECISION (Transact-SQL)

@@NESTLEVEL (Transact-SQL)

@@OPTIONS (Transact-SQL)

@@PACK_RECEIVED (Transact-SQL)

@@PACK_SENT (Transact-SQL)

@@PACKET_ERRORS (Transact-SQL)

@@PROCID (Transact-SQL)

@@REMSERVER (Transact-SQL)

@@ROWCOUNT (Transact-SQL)

@@SERVERNAME (Transact-SQL)

@@SERVICENAME (Transact-SQL)

@@SPID (Transact-SQL)

@@TEXTSIZE (Transact-SQL)

@@TIMETICKS (Transact-SQL)

@@TOTAL_ERRORS (Transact-SQL)

@@TOTAL_READ (Transact-SQL)

@@TOTAL_WRITE (Transact-SQL)

@@TRANCOUNT (Transact-SQL)

@@VERSION (Transact-SQL)

ABS (Transact-SQL)

ACOS (Transact-SQL)

ADD SIGNATURE (Transact-SQL)

ALL (Transact-SQL)

ALTER APPLICATION ROLE (Transact-SQL)

ALTER ASSEMBLY (Transact-SQL)

ALTER ASYMMETRIC KEY (Transact-SQL)

ALTER AUTHORIZATION (Transact-SQL)

ALTER CERTIFICATE (Transact-SQL)

ALTER CREDENTIAL (Transact-SQL)

ALTER DATABASE (Transact-SQL)

ALTER ENDPOINT (Transact-SQL)

ALTER FULLTEXT CATALOG (Transact-SQL)

ALTER FULLTEXT INDEX (Transact-SQL)

ALTER FUNCTION (Transact-SQL)

ALTER INDEX (Transact-SQL)

ALTER LOGIN (Transact-SQL)

ALTER MASTER KEY (Transact-SQL)

ALTER MESSAGE TYPE (Transact-SQL)

ALTER PARTITION FUNCTION (Transact-SQL)

ALTER PARTITION SCHEME (Transact-SQL)

ALTER PROCEDURE (Transact-SQL)

ALTER QUEUE (Transact-SQL)

ALTER REMOTE SERVICE BINDING (Transact-SQL)

ALTER ROLE (Transact-SQL)

ALTER ROUTE (Transact-SQL)

ALTER SCHEMA (Transact-SQL)

ALTER SERVICE (Transact-SQL)

ALTER SERVICE MASTER KEY (Transact-SQL)

ALTER SYMMETRIC KEY (Transact-SQL)

ALTER TABLE (Transact-SQL)

ALTER TRIGGER (Transact-SQL)

ALTER USER (Transact-SQL)

ALTER VIEW (Transact-SQL)

ALTER XML SCHEMA COLLECTION (Transact-SQL)

AND (Transact-SQL)

ANY (Transact-SQL)

APPLOCK_MODE (Transact-SQL)

APPLOCK_TEST (Transact-SQL)

APP_NAME (Transact-SQL)

ASCII (Transact-SQL)

ASIN (Transact-SQL)

ASSEMBLYPROPERTY (Transact-SQL)

AsymKey_ID (Transact-SQL)

ATAN (Transact-SQL)

ATN2 (Transact-SQL)

AVG (Transact-SQL)

BACKUP (Transact-SQL)

BACKUP CERTIFICATE (Transact-SQL)

BACKUP MASTER KEY (Transact-SQL)

BACKUP SERVICE MASTER KEY (Transact-SQL)

BEGIN...END (Transact-SQL)

BEGIN CONVERSATION TIMER (Transact-SQL)

BEGIN DIALOG CONVERSATION (Transact-SQL)

BEGIN DISTRIBUTED TRANSACTION (Transact-SQL)

BEGIN TRANSACTION (Transact-SQL)

BETWEEN (Transact-SQL)

binary 和 varbinary (Transact-SQL)

BINARY_CHECKSUM

bit (Transact-SQL)

BREAK (Transact-SQL)

BULK INSERT (Transact-SQL)

CASE (Transact-SQL)

CAST 和 CONVERT (Transact-SQL)

CATCH (TRY...CATCH) (Transact-SQL)

CEILING (Transact-SQL)

CertProperty (Transact-SQL)

Cert_ID (Transact-SQL)

char 和 varchar (Transact-SQL)

CHAR (Transact-SQL)

CHARINDEX (Transact-SQL)

CHECKPOINT (Transact-SQL)

CHECKSUM (Transact-SQL)

CHECKSUM_AGG (Transact-SQL)

CLOSE (Transact-SQL)

CLOSE MASTER KEY (Transact-SQL)

CLOSE SYMMETRIC KEY (Transact-SQL)

COALESCE (Transact-SQL)

COLLATE (Transact-SQL)

COLLATIONPROPERTY (Transact-SQL)

COL_LENGTH (Transact-SQL)

COL_NAME (Transact-SQL)

COLUMNPROPERTY (Transact-SQL)

COLUMNS_UPDATED (Transact-SQL)

COMMIT TRANSACTION (Transact-SQL)

COMMIT WORK (Transact-SQL)

COMPUTE (Transact-SQL)

常數 (Transact-SQL)

CONTAINS (Transact-SQL)

CONTAINSTABLE (Transact-SQL)

CONTEXT_INFO (Transact-SQL)

CONTINUE (Transact-SQL)

流程控制語言 (Transact-SQL)

CONVERT (Transact-SQL)

COS (Transact-SQL)

COT (Transact-SQL)

COUNT (Transact-SQL)

COUNT_BIG (Transact-SQL)

CREATE AGGREGATE (Transact-SQL)

CREATE APPLICATION ROLE (Transact-SQL)

CREATE ASSEMBLY (Transact-SQL)

CREATE ASYMMETRIC KEY (Transact-SQL)

CREATE CERTIFICATE (Transact-SQL)

CREATE CONTRACT (Transact-SQL)

CREATE CREDENTIAL (Transact-SQL)

CREATE DATABASE (Transact-SQL)

CREATE DEFAULT (Transact-SQL)

CREATE ENDPOINT (Transact-SQL)

CREATE EVENT NOTIFICATION (Transact-SQL)

CREATE FULLTEXT CATALOG (Transact-SQL)

CREATE FULLTEXT INDEX (Transact-SQL)

CREATE FUNCTION (Transact-SQL)

CREATE INDEX (Transact-SQL)

CREATE LOGIN (Transact-SQL)

CREATE MASTER KEY (Transact-SQL)

CREATE MESSAGE TYPE (Transact-SQL)

CREATE PARTITION FUNCTION (Transact-SQL)

CREATE PARTITION SCHEME (Transact-SQL)

CREATE PROCEDURE (Transact-SQL)

CREATE QUEUE (Transact-SQL)

CREATE REMOTE SERVICE BINDING (Transact-SQL)

CREATE ROLE (Transact-SQL)

CREATE ROUTE (Transact-SQL)

CREATE RULE (Transact-SQL)

CREATE SCHEMA (Transact-SQL)

CREATE SERVICE (Transact-SQL)

CREATE STATISTICS (Transact-SQL)

CREATE SYMMETRIC KEY (Transact-SQL)

CREATE SYNONYM (Transact-SQL)

CREATE TABLE (Transact-SQL)

CREATE TRIGGER (Transact-SQL)

CREATE TYPE (Transact-SQL)

CREATE USER (Transact-SQL)

CREATE VIEW (Transact-SQL)

CREATE XML SCHEMA COLLECTION (Transact-SQL)

CURRENT_REQUEST_ID (Transact-SQL)

CURRENT_TIMESTAMP (Transact-SQL)

CURRENT_USER (Transact-SQL)

cursor (Transact-SQL)

CURSOR_STATUS (Transact-SQL)

資料指標 (Transact-SQL)

DATABASEPROPERTY (Transact-SQL)

DATABASEPROPERTYEX (Transact-SQL)

DATABASE_PRINCIPAL_ID (Transact-SQL)

資料類型 (Transact-SQL)

DATALENGTH (Transact-SQL)

DATEADD (Transact-SQL)

DATEDIFF (Transact-SQL)

DATENAME (Transact-SQL)

DATEPART (Transact-SQL)

日期和時間 (Transact-SQL)

DAY (Transact-SQL)

DB_ID (Transact-SQL)

DB_NAME (Transact-SQL)

DBCC (Transact-SQL)

DEALLOCATE (Transact-SQL)

decimal 和 numeric (Transact-SQL)

DECLARE @local_variable (Transact-SQL)

DECLARE CURSOR (Transact-SQL)

DecryptByAsymKey (Transact-SQL)

DecryptByCert (Transact-SQL)

DecryptByKey (Transact-SQL)

DecryptByKeyAutoAsymKey (Transact-SQL)

DecryptByKeyAutoCert (Transact-SQL)

DecryptByPassPhrase (Transact-SQL)

DEGREES (Transact-SQL)

DELETE (Transact-SQL)

DENSE_RANK (Transact-SQL)

DENY (Transact-SQL)

DIFFERENCE (Transact-SQL)

DISABLE TRIGGER (Transact-SQL)

DROP AGGREGATE (Transact-SQL)

DROP APPLICATION ROLE (Transact-SQL)

DROP ASSEMBLY (Transact-SQL)

DROP ASYMMETRIC KEY (Transact-SQL)

DROP CERTIFICATE (Transact-SQL)

DROP CONTRACT (Transact-SQL)

DROP CREDENTIAL (Transact-SQL)

DROP DATABASE (Transact-SQL)

DROP DEFAULT (Transact-SQL)

DROP ENDPOINT (Transact-SQL)

DROP EVENT NOTIFICATION (Transact-SQL)

DROP FULLTEXT CATALOG (Transact-SQL)

DROP FULLTEXT INDEX (Transact-SQL)

DROP FUNCTION (Transact-SQL)

DROP INDEX (Transact-SQL)

DROP LOGIN (Transact-SQL)

DROP MASTER KEY (Transact-SQL)

DROP MESSAGE TYPE (Transact-SQL)

DROP PARTITION FUNCTION (Transact-SQL)

DROP PARTITION SCHEME (Transact-SQL)

DROP PROCEDURE (Transact-SQL)

DROP QUEUE (Transact-SQL)

DROP REMOTE SERVICE BINDING (Transact-SQL)

DROP ROLE (Transact-SQL)

DROP ROUTE (Transact-SQL)

DROP RULE (Transact-SQL)

DROP SCHEMA (Transact-SQL)

DROP SERVICE (Transact-SQL)

DROP SIGNATURE (Transact-SQL)

DROP STATISTICS (Transact-SQL)

DROP SYMMETRIC KEY (Transact-SQL)

DROP SYNONYM (Transact-SQL)

DROP TABLE (Transact-SQL)

DROP TRIGGER (Transact-SQL)

DROP TYPE (Transact-SQL)

DROP USER (Transact-SQL)

DROP VIEW (Transact-SQL)

DROP XML SCHEMA COLLECTION (Transact-SQL)

DUMP (Transact-SQL)

ELSE (IF...ELSE) (Transact-SQL)

ENABLE TRIGGER (Transact-SQL)

EncryptByAsymKey (Transact-SQL)

EncryptByCert (Transact-SQL)

EncryptByKey (Transact-SQL)

EncryptByPassPhrase (Transact-SQL)

END (BEGIN...END) (Transact-SQL)

END CONVERSATION (Transact-SQL)

ERROR_LINE (Transact-SQL)

ERROR_MESSAGE (Transact-SQL)

ERROR_NUMBER (Transact-SQL)

ERROR_PROCEDURE (Transact-SQL)

ERROR_SEVERITY (Transact-SQL)

ERROR_STATE (Transact-SQL)

EVENTDATA (Transact-SQL)

EXCEPT 和 INTERSECT (Transact-SQL)

EXECUTE AS (Transact-SQL)

EXECUTE AS 子句 (Transact-SQL)

EXECUTE (Transact-SQL)

EXISTS (Transact-SQL)

EXP (Transact-SQL)

運算式 (Transact-SQL)

FETCH (Transact-SQL)

DB_ID (Transact-SQL)

FILE_IDEX (Transact-SQL)

FILE_NAME (Transact-SQL)

FILEGROUP_ID (Transact-SQL)

FILEGROUP_NAME (Transact-SQL)

FILEGROUPPROPERTY (Transact-SQL)

FILEPROPERTY (Transact-SQL)

float 和 real (Transact-SQL)

FLOOR (Transact-SQL)

fn_get_sql (Transact-SQL)

fn_helpcollations (Transact-SQL)

fn_listextendedproperty (Transact-SQL)

fn_my_permissions (Transact-SQL)

fn_servershareddrives (Transact-SQL)

fn_trace_geteventinfo (Transact-SQL)

fn_trace_getfilterinfo (Transact-SQL)

fn_trace_getinfo (Transact-SQL)

fn_trace_gettable (Transact-SQL)

fn_virtualfilestats (Transact-SQL)

fn_virtualservernodes (Transact-SQL)

FOR 子句 (Transact-SQL)

FORMATMESSAGE (Transact-SQL)

FREETEXT (Transact-SQL)

FREETEXTTABLE (Transact-SQL)

FROM (Transact-SQL)

FULLTEXTCATALOGPROPERTY (Transact-SQL)

FULLTEXTSERVICEPROPERTY (Transact-SQL)

函數 (Transact-SQL)

GET CONVERSATION GROUP (Transact-SQL)

GET_TRANSMISSION_STATUS (Transact-SQL)

GETANSINULL (Transact-SQL)

GETDATE (Transact-SQL)

GETUTCDATE (Transact-SQL)

GO (Transact-SQL)

GOTO (Transact-SQL)

GRANT (Transact-SQL)

GROUP BY (Transact-SQL)

GROUPING (Transact-SQL)

HAS_DBACCESS (Transact-SQL)

Has_Perms_By_Name (Transact-SQL)

HashBytes (Transact-SQL)

HAVING (Transact-SQL)

提示 (Transact-SQL)

HOST_ID (Transact-SQL)

HOST_NAME (Transact-SQL)

IDENT_CURRENT (Transact-SQL)

IDENT_INCR (Transact-SQL)

IDENT_SEED (Transact-SQL)

IDENTITY (函數) (Transact-SQL)

IDENTITY (屬性) (Transact-SQL)

IF...ELSE (Transact-SQL)

image (Transact-SQL)

IN (Transact-SQL)

INDEXKEY_PROPERTY (Transact-SQL)

INDEXPROPERTY (Transact-SQL)

INDEX_COL (Transact-SQL)

INSERT (Transact-SQL)

int、bigint、smallint 和 tinyint (Transact-SQL)

INTO 子句 (Transact-SQL)

IS_MEMBER (Transact-SQL)

IS_SRVROLEMEMBER (Transact-SQL)

ISDATE (Transact-SQL)

IS [NOT] NULL (Transact-SQL)

ISNULL (Transact-SQL)

ISNUMERIC (Transact-SQL)

Key_GUID (Transact-SQL)

Key_ID (Transact-SQL)

KILL (Transact-SQL)

KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)

KILL STATS JOB (Transact-SQL)

LEFT (Transact-SQL)

LEN (Transact-SQL)

LIKE (Transact-SQL)

LOAD (Transact-SQL)

LOG (Transact-SQL)

LOG10 (Transact-SQL)

LOGINPROPERTY (Transact-SQL)

LOWER (Transact-SQL)

LTRIM (Transact-SQL)

MAX (Transact-SQL)

MIN (Transact-SQL)

MIN_ACTIVE_ROWVERSION (Transact-SQL)

money 和 smallmoney (Transact-SQL)

MONTH (Transact-SQL)

MOVE CONVERSATION (Transact-SQL)

NCHAR (Transact-SQL)

nchar 和 nvarchar (Transact-SQL)

NEWID (Transact-SQL)

NEWSEQUENTIALID()

NOT (Transact-SQL)

ntext、text 和 image (Transact-SQL)

NTILE (Transact-SQL)

NULLIF (Transact-SQL)

numeric (Transact-SQL)

OBJECT_DEFINITION (Transact-SQL)

OBJECT_ID (Transact-SQL)

OBJECT_NAME (Transact-SQL)

OBJECT_SCHEMA_NAME (Transact-SQL)

OBJECTPROPERTY (Transact-SQL)

OBJECTPROPERTYEX (Transact-SQL)

OPEN (Transact-SQL)

OPEN MASTER KEY (Transact-SQL)

OPEN SYMMETRIC KEY (Transact-SQL)

OPENDATASOURCE (Transact-SQL)

OPENQUERY (Transact-SQL)

OPENROWSET (Transact-SQL)

OPENXML (Transact-SQL)

運算子 (Transact-SQL)

OPTION 子句 (Transact-SQL)

OR (Transact-SQL)

ORDER BY 子句 (Transact-SQL)

ORIGINAL_LOGIN (Transact-SQL)

OUTPUT 子句 (Transact-SQL)

OVER 子句 (Transact-SQL)

PARSENAME (Transact-SQL)

PATINDEX (Transact-SQL)

PERMISSIONS (Transact-SQL)

PI (Transact-SQL)

POWER (Transact-SQL)

述詞 (Transact-SQL)

PRINT (Transact-SQL)

PUBLISHINGSERVERNAME (Transact-SQL)

QUOTENAME (Transact-SQL)

RADIANS (Transact-SQL)

RAISERROR (Transact-SQL)

RAND (Transact-SQL)

RANK (Transact-SQL)

READTEXT (Transact-SQL)

real (Transact-SQL)

RECEIVE (Transact-SQL)

RECONFIGURE (Transact-SQL)

REPLACE (Transact-SQL)

REPLICATE (Transact-SQL)

保留關鍵字 (Transact-SQL)

用來還原、復原和管理備份的 RESTORE 陳述式

RESTORE MASTER KEY (Transact-SQL)

RESTORE SERVICE MASTER KEY (Transact-SQL)

RETURN (Transact-SQL)

REVERSE (Transact-SQL)

REVERT (Transact-SQL)

REVOKE (Transact-SQL)

RIGHT (Transact-SQL)

ROLLBACK TRANSACTION (Transact-SQL)

ROLLBACK WORK (Transact-SQL)

ROUND (Transact-SQL)

ROWCOUNT_BIG (Transact-SQL)

ROW_NUMBER (Transact-SQL)

RTRIM (Transact-SQL)

SAVE TRANSACTION (Transact-SQL)

SCHEMA_ID (Transact-SQL)

SCHEMA_NAME (Transact-SQL)

SCOPE_IDENTITY (Transact-SQL)

搜尋條件 (Transact-SQL)

SELECT @local_variable (Transact-SQL)

SELECT (Transact-SQL)

SEND (Transact-SQL)

SERVERPROPERTY (Transact-SQL)

SESSION_USER (Transact-SQL)

SESSIONPROPERTY (Transact-SQL)

SET @local_variable (Transact-SQL)

SET (Transact-SQL)

SETUSER (Transact-SQL)

SHUTDOWN (Transact-SQL)

SIGN (Transact-SQL)

SignByAsymKey (Transact-SQL)

SignByCert (Transact-SQL)

SIN (Transact-SQL)

smalldatetime (Transact-SQL)

smallint (Transact-SQL)

smallmoney (Transact-SQL)

SOME | ANY (Transact-SQL)

SOUNDEX (Transact-SQL)

SPACE (Transact-SQL)

sql_variant (Transact-SQL)

SQL_VARIANT_PROPERTY (Transact-SQL)

SQRT (Transact-SQL)

SQUARE (Transact-SQL)

STATS_DATE (Transact-SQL)

STDEV (Transact-SQL)

STDEVP (Transact-SQL)

STR (Transact-SQL)

STUFF (Transact-SQL)

SUBSTRING (Transact-SQL)

SUM (Transact-SQL)

SUSER_ID (Transact-SQL)

SUSER_NAME (Transact-SQL)

SUSER_SID (Transact-SQL)

SUSER_SNAME (Transact-SQL)

系統預存程序 (Transact-SQL)

系統資料表 (Transact-SQL)

系統檢視 (Transact-SQL)

sys.fn_builtin_permissions (Transact-SQL)

sys.fn_translate_permissions (Transact-SQL)

sys.login_token (Transact-SQL)

sys.user_token (Transact-SQL)

SYSTEM_USER (Transact-SQL)

資料表 (Transact-SQL)

TAN (Transact-SQL)

TERTIARY_WEIGHTS

text (Transact-SQL)

TEXTPTR (Transact-SQL)

TEXTVALID (Transact-SQL)

timestamp (Transact-SQL)

tinyint (Transact-SQL)

TOP (Transact-SQL)

追蹤旗標 (Transact-SQL)

交易 (Transact-SQL)

TRY...CATCH (Transact-SQL)

TRIGGER_NESTLEVEL (Transact-SQL)

TRUNCATE TABLE (Transact-SQL)

TYPE_ID (Transact-SQL)

TYPE_NAME (Transact-SQL)

TYPEPROPERTY (Transact-SQL)

UNICODE (Transact-SQL)

UNION (Transact-SQL)

uniqueidentifier (Transact-SQL)

UPDATE (Transact-SQL)

UPDATE() (Transact-SQL)

UPDATE STATISTICS (Transact-SQL)

UPDATETEXT (Transact-SQL)

UPPER (Transact-SQL)

USE (Transact-SQL)

USER (Transact-SQL)

USER_ID (Transact-SQL)

USER_NAME (Transact-SQL)

VAR (Transact-SQL)

varbinary (Transact-SQL)

varchar (Transact-SQL)

VARP (Transact-SQL)

VerifySignedByCert (Transact-SQL)

VerifySignedByAsmKey (Transact-SQL)

WAITFOR (Transact-SQL)

WHERE (Transact-SQL)

WHILE (Transact-SQL)

WITH common_table_expression (Transact-SQL)

WITH XMLNAMESPACES (Transact-SQL)

WRITETEXT (Transact-SQL)

XACT_STATE (Transact-SQL)

xml (Transact-SQL)

xml_schema_namespace (Transact-SQL)

YEAR (Transact-SQL)

Minimize

本主題尚未接受評分 - 為這個主題評分

DROP PARTITION SCHEME (Transact-SQL)

SQL Server 2005

從目前資料庫移除資料分割配置。資料分割配置是利用 CREATE PARTITION SCHEME 來建立，且利用 ALTER PARTITION SCHEME 來修改。

主題連結圖示 Transact-SQL 語法慣例


DROP PARTITION SCHEME partition_scheme_name [ ; ]

partition_scheme_name: 這是您要卸除的資料分割配置名稱。

只有在目前沒有資料表或索引在使用資料分割配置時，才可以卸除資料分割配置。如果有資料表或索引在使用資料分割配置，DROP PARTITION SCHEME 便會傳回錯誤。DROP PARTITION SCHEME 不會移除檔案群組本身。

下列權限可用來執行 DROP PARTITION SCHEME：

ALTER ANY DATASPACE 權限。這個權限預設會授與系統管理員 (sysadmin) 固定伺服器角色，以及 db_owner 和 db_ddladmin 固定資料庫角色的成員。
建立資料分割配置之資料庫的 CONTROL 或 ALTER 權限。
在建立資料分割配置的資料庫中，其伺服器的 CONTROL SERVER 或 ALTER ANY DATABASE 權限。

下列範例會從目前資料庫中，卸除資料分割配置 myRangePS1：

DROP PARTITION SCHEME myRangePS1;

參考

CREATE PARTITION SCHEME (Transact-SQL)
ALTER PARTITION SCHEME (Transact-SQL)
sys.partition_schemes (Transact-SQL)
EVENTDATA (Transact-SQL)
sys.data_spaces (Transact-SQL)
sys.destination_data_spaces (Transact-SQL)
sys.partitions (Transact-SQL)
sys.tables (Transact-SQL)
sys.indexes (Transact-SQL)
sys.index_columns (Transact-SQL)

說明及資訊

取得 SQL Server 2005 協助

本文對您有任何幫助嗎？是否

不正確

不夠深入

需要更多程式碼範例

翻譯需要加強。

(剩餘 1500 個字元)

社群新增項目

Microsoft 正展開一份線上問卷調查，了解您對於 MSDN 網站的看法。如果您選擇參加，您離開 MSDN 網站時即會顯示線上問卷調查。

您是否想要參加？

隱私權聲明

© 2014 Microsoft. 著作權所有，並保留一切權利。