다음을 통해 공유

Names Collection

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The Names collection is a string container used to manipulate a list of named objects.

Properties

Count Property

Methods

Add Method

Refresh Method

FindName Method

Remove Method (Collections)

Insert Method

Replace Method

Item Method

주의

The Names collection is implemented for the Parameters property of the Configuration object, and for the KeyColumns and ReferencedColumns properties of the Key object. For more information about using the Names collection in Microsoft® SQL Server™ administration, see Configuration Objectand Key Object.

When using the Item method, the Names collection supports member identification using only ordinal reference syntax. For example:

Dim     strKeyColumnName as String
Dim     iColumn as Integer
For iColumn = 1 to oKey.KeyColumns.Count
    strKeyColumnName = oKey.KeyColumns(iColumn)
Next iColumn

When using the Remove method, the Names collection supports member identification using either name or ordinal reference syntax. For example:

oKey.KeyColumns.Remove("EmployeeID")

Or:

oKey.KeyColumns.Remove(1)