The Names collection is a string container used to manipulate a list of named objects.
The Names collection is implemented for the Parameters property of the Configuration object, and the KeyColumns and ReferencedColumns properties of the Key object. For more information about using the Names collection in Microsoft® SQL Server™ administration, see Configuration Object and 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)
| Add Method | Refresh Method |
| FindName Method | Remove Method (Collections) |
| Insert Method | Replace Method |
| Item Method |