Interesting glitch or not on MSSQL

[Jochen Peters]

>> I can't delete last field in the table!!!
>>
>> ALTER TABLE DROP COLUMN failed because 'asd' is the only data column 
>> in
>> table 'Table1'. A table must have at least one data column.
>
> Well, This is logically actually!
Hhmm..
It is defined as to be logical :-)
For stupid user this is not logical!

It would be the same to say:
You can't delete the last file from your HD because a HD must always 
contain
at least one file...:-)

>
> I think we also should do this, and have such error code.
>
> Yes, in kernel we can have table without field, and we do even tests 
> on it.
> But this have no sense for users of db kernel
When we can do it technical - why not do it?
Valentina shouldn't have the same limits then other db's..


>
-- 
Best regards,
Jochen Peters
PIIT GmbH

------------------------------------
http://www.valentina-db.de