SQL::Connection::GenerateDropIndexStatement()

Syntax

SQL_Statement as C = SQL::Connection::GenerateDropIndexStatement( Owner as C, Table as C, Index as C )

Argument	Description
SQL_Statement	An add user group statement appropriate for the database.
Owner	The owner of the table.
Table	The name of the table.
Index	The name of the index.

Description

The .GenerateDropIndexStatement() method returns the SQL statement that will delete the specified table index.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

Example

dim conn as SQL::Connection

conn.open("{A5API=Access,FileName='C:\Program Files\A5V8\MDBFiles\Alphasports.mdb',UserName='Admin'}")

? conn.GenerateDropIndexStatement("", "Customer", "foo")

= "DROP INDEX foo ON Customer"