| Subject | Re: [ib-support] ALTER INDEX in a Stored Procedure |
|---|---|
| Author | Martijn Tonies |
| Post date | 2003-06-03T20:12:31Z |
Hi Robert,
Unless - if you're using Fb 1.5, you can use:
EXECUTE STATEMENT 'ALTER INDEX name ... ';
With regards,
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com
> I can't seem to ALTER INDEX or SET STATISTICS in a stored procedure. AmBoth are DDL commands. Not possible in a stored procedure.
> I missing anything? Thanks!
Unless - if you're using Fb 1.5, you can use:
EXECUTE STATEMENT 'ALTER INDEX name ... ';
With regards,
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com