29 Jan
2008
29 Jan
'08
8:18 p.m.
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.