Re: tables and columns

thanks for answer,

I think the most of my problems are solved with a special oracle - sql - manual :-).
Is there any webside ?

At this moment I checked the sql - command : "ALTER TABLE TeSiPrivilege DROP COLUMN columnname;" But it doesn't work.
SQL *Plus give me the error message : "keyword missed" with a star by COLUMN.
In my SQL-manual I found the following definition of ALTER:

ALTER TABLE table {ADD {COLUMN field type [(size)] [NOT NULL] [CONSTRAINT index] |
CONSTRAINT multifieldindex} |
DROP {COLUMN field I CONSTRAINT indexname} }

Is it not true ?

thanks , Leif Received on Wed Feb 09 2000 - 04:53:22 CST