Re: Does ORACLE has any stupid restrictions like MS-SQL

From: Jim Poland <jim.poland_at_csipros.com>
Date: 1997/03/20
Message-ID: <33314A2D.5592@csipros.com>#1/1

NNOOR wrote:
>
> We are getting increasingly frustrated with the restrictions in the
> MS SQL Server, especially when it comes to modifying the columns of
> a table. It does not let you drop a column, change data type or
> add/remove NULL restrictions. As a result, we are considering
> moving off the SQL Server as we are so early on in the development
> stage that we can afford it.
>
> We are wondering if there any such restrictions/gotchas in the
> Oracle that we have to be aware of We will appreciate any help
> on this issue.
>
> Thanks very much!!!
>
> Regards,
> Nasir (nnoor_at_cris.com)

I don't believe you are permitted to drop a column. Other examples you cited are permissible, depending on the data already in the column.

Jim Received on Thu Mar 20 1997 - 00:00:00 CST