共用方式為


TextFileGroup Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The TextFileGroup property specifies the Microsoft SQL Server filegroup used to maintain long, variable-length data stored in the referenced Table object.

語法

object
.TextFileGroup [ =value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list
  • value
    A string that identifies an existing filegroup by name

Data Type

String

Modifiable

Read/write when using the Table object to create a SQL Server table. Read-only when the Table object references an existing table.

Prototype (C/C++)

HRESULT GetTextFileGroup(SQLDMO_LPBSTR pRetVal);
HRESULT SetTextFileGroup(SQLDMO_LPCSTR NewValue);
ms134955.note(zh-tw,SQL.90).gif附註:
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

備註

A SQL Server filegroup categorizes the operating system files containing data from a single database to simplify database administration tasks such as backup. Within a database, filegroup use is directed as tables and indexes are created.

When using the Table object to create a SQL Server table, direct operating system file use by setting the FileGroup property of the Table object. By default, the filegroup specified stores all data for the SQL Server table. Override the default behavior by setting the TextFileGroup property to direct storage of long, variable-length data in the table.

For SQL Server, a column with data type image, ntext, or text is considered to be long, variable-length. When creating a table, you can direct long, variable-length data storage only in the presence of a column defined using a qualifying data type.

ms134955.note(zh-tw,SQL.90).gif附註:
The filegroup used to store table row data is also specified when a clustered index is defined on the table. For more information, see CREATE INDEX (Transact-SQL).

Applies To:

Table Object