Hi,

> can i do this?
>
> CREATE PROCEDURE sp_test
> (tabname VARCHAR(24), colname VARCHAR(24), datatype VARCHAR(24))
> AS
> BEGIN
> ALTER TABLE :tabname ADD :colname :datatype;
> END
>
> how can i alter table (add new columns) in stored procedure?

You can't.

Unless you're using Firebird 1.5 and use EXECUTE STATEMENT -
this allows you to dynamically create an SQL statement and execute
it.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com