INDEX-EXISTS-P
Prev | Functional Data Definition Language (FDDL) | Next

## Name

INDEX-EXISTS- — Tests for the existence of a database index.Function

## Syntax

          index-exists-p name &key owner database => result

## Arguments and Values

`name`

  The name of the index as a string, symbol or SQL expression.

`owner`

  A string, `NIL` or :all.

`database`

  A database object which defaults to *default-database*.

`result`

  A Boolean.

## Description

Tests for the existence of an SQL index called `name` in `database` which defaults to *default-database*. `owner` is `NIL` by default which means that only indexes owned by users are examined. If `owner` is a string denoting a user name, only indexes owned by `owner` are examined. If `owner` is :all then all indexes are examined.

## Examples

    (index-exists-p [bar])
    => T

## Side Effects

None.

## Affected by

*default-database*

## Exceptional Situations

None.

## See Also

`create-index`
`drop-index`
`list-indexes`

## Notes

`index-exists-p` is a CLSQL extension.

Prev | Up | Next
LIST-INDEXES | Home | ATTRIBUTE-TYPE