Hi List,

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?

thanks