Re: [MonetDB-users] ALTER TABLE doesn't work in MonetDB !!

29 Jan 2008

      The Syntax only works in the default schema.

 If i try to alter a table in a user created schema then it's throwing the
same Error "Table Doesn't exists" !!!

 Here is my Test Case..

[CODE]

create table tmp.collection_info( test_col varchar(100));

ALTER TABLE "tmp"."COLLECTION_INFO" ADD COLUMN test_col1  varchar(256);

ALTER TABLE tmp.COLLECTION_INFO ADD COLUMN test_col2 varchar(256);

ALTER TABLE "tmp"."collection_info" ADD COLUMN test_col3  varchar(256);

ALTER TABLE tmp.collection_info ADD COLUMN test_col4  varchar(256);

[/CODE]

Regards
Sateesh
-- 
View this message in context: http://www.nabble.com/ALTER-TABLE-doesn%27t-work-in-MonetDB-%21%21-tp1516802...
Sent from the monetdb-users mailing list archive at Nabble.com.

Re: [MonetDB-users] ALTER TABLE doesn't work in MonetDB !!

sateesh