Re: Can not drop the view

10 Sep 2014

      Thank you Niels,
Delete seems to work.
Radovan

On 09/08/2014 09:04 AM, Niels Nes wrote:
...
...
Hi Niels,
There are 3 views that have multiple definition in the data dictionary.
For example:
select * from sys.tables where name='stav_skladu_historie'
On Mon, Sep 08, 2014 at 08:52:29AM +0200, Radovan Bičiště wrote:
likely the last (highest id) is the one to keep.
so a delete from _tables where id in (16884, ..);
should do the trick.
Niels
ps first backup!