Clear Method

This method clears the schema columns.

Syntax

IColumns.Clear

Remarks

This method is not permanent unless you subsequently call the ISearchSchema.Save method.

Example

The following example clears all schema columns.

Option Explicit 
On Error Resume Next

Dim objSearchAdmin, objBuildServer, objCatalogs, objCatalog, objSchema, objColumns 

Set objSearchAdmin = CreateObject("Search.SearchAdmin.1")
Set objBuildServer = objSearchAdmin.BuildServer
Set objCatalogs = objBuildServer.BuildCatalogs 
Set objCatalog  = objCatalogs("KMSampleCatalog1")
Set objSchema   = objCatalog.objSchema 
Set objColumns  = objSchema.objColumns

objColumns.Clear

'Release objects
Set objColumns  = Nothing 
Set objSchema   = Nothing 
Set objCatalog  = Nothing 
Set objCatalogs = Nothing 
Set objBuildServer = Nothing 
Set objSearchAdmin = Nothing 
 

See Also

Count, Remove


© 1997-1998 Microsoft Corporation. All rights reserved.