次の方法で共有


FileGroup Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The FileGroup object exposes the attributes of a Microsoft SQL Server filegroup.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

Properties

Default Property (FileGroup)

ReadOnly Property

ID Property

Size Property

Name Property

 

Methods

CheckFilegroup Method

EnumObjects Method

CheckFilegroupDataOnly Method

Remove Method (Objects)

EnumFiles Method (FileGroup)

 

解説

A SQL Server filegroup categorizes the operating system files containing data from a single SQL Server database to simplify database administration tasks, such as backup. A filegroup is a property of a SQL Server database and cannot contain the operating system files of more than one database, though a single database can contain more than one filegroup.

When a database is created, it is created on exactly one filegroup named PRIMARY. After database creation, filegroups can be added to the database. A filegroup name can be specified in a CREATE TABLE or CREATE INDEX statement, directing data storage for a database.

With the FileGroup object, you can:

  • Create a SQL Server filegroup.
  • Remove an existing SQL Server filegroup.
  • Manage the physical storage of a SQL Server database by adding or removing DBFile objects to the DBFiles collection.

The Name property of a FileGroup object uses the SQL Server data type sysname. The Name property must be unique within the list of filegroups of a SQL Server database.

To create a SQL Server filegroup

  1. Create a FileGroup object.

  2. Set the Name property.

  3. Add the FileGroup object to the FileGroups collection of a connected Database object.

ms141041.note(ja-jp,SQL.90).gifメモ :
The FileGroup object is compatible with instances of SQL Server version 7.0 and later. However, the FileGroup2 object extends the functionality of the FileGroup object for use with features that were introduced in SQL Server 2000.

参照

関連項目

FileGroup2 Object

その他の技術情報

CREATE INDEX (Transact-SQL)
CREATE TABLE (Transact-SQL)

ヘルプおよび情報

SQL Server 2005 の参考資料の入手