> I need to do this from winthin my application with SQL or if
> not possible with the API.

If your using Delphi take a look at IB Admin components, not sure about
other languages sorry.

Rgds

Si Carter
http://www.tectsoft.net/