This section demonstrates dropping an empty text index. The example drops the proxy tables associated with the Adaptive Server text index, but leaves all the default directories and files in the collections directory structure of EFTS text indexes. isql -Sase1501sunbox -Usa -P -w2048 Dxml_db1 sp_drop_text_index 'address_tbl.ti_address_tbl' go (return status = 0) quit
