[MonetDB-users] Re naming a column via MAL/SQL

3 Feb 2009

      Hi guys,

Is there a way to rename an existing column within a table via SQL?

(the RENAME COLUMN syntax is not supported as it seems)

and if not, can i do it via MAL?

I tried to use MAL as follows, but after i do, the DB seems to get corrupt
when i try to access the specific table.

include sql; 
sql.init();
bat1 := sql.bind("sys","t1","Field1",0);
bat.setName(bat1,"Field2");
bat.setPersistent(bat1,true);
bot.commit;

Thanks & Best Regards...

-- 
View this message in context: http://www.nabble.com/Renaming-a-column-via-MAL-SQL-tp21807788p21807788.html
Sent from the monetdb-users mailing list archive at Nabble.com.

[MonetDB-users] Re naming a column via MAL/SQL

Alfred Nordman