Hello
In the ALTER TABLE ADD <column definition> statement, it seems to be a
error in the manual or in the parser.
The manual says that the <column definition> is the same as do it in the
CREATE TABLE, except can't use domain with default and can't use the LONG
datatype (why?).
The following statements fails in an empty table (when all must succeed)
ALTER TABLE <table name> ADD <column name><column type> NOT NULL.
-7003 NOT NULL not allowed
ALTER TABLE <table name> ADD <column name><column type> DEFAULT
<default-value>.
-7004 DEFAULT not allowed
ALTER TABLE <table name> ADD <column name><column type> PRIMARY KEY.
-7002 KEY not allowed
The following statements succeed
ALTER TABLE <table name> ADD <column name><column type>.
ALTER TABLE <table name> ADD <column name><column type> CHECK <check
expression>.
ALTER TABLE <table name> ADD <column name><column type> REFERENCES
<references clausule>.
Regards
Blas Rodriguez Somoza.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
