Names Collection
后续版本的 Microsoft SQL Server 将删除该功能。 请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。
The Names collection is a string container used to manipulate a list of named objects.
Methods
注释
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)