| Author |
table or view does not exists
|
|
| anonymous 2005-04-06, 7:01 am |
| Hi,
We are using SQL Anywhere 5.5.x and 6.x sometime we need to re-creating
views so we drop them and create again, while dropping database gives error
that object does not exists and when we try to create them it says object
already exists!!! May I know what could be the reason here?
I know these version are no more suported but customer does not wants to
upgrade database right now so until they decide to upgrade we need to
support this.
Regards,
| |
| Markus Hofer 2005-04-06, 7:01 am |
| How do you delete and create the views (SQL statements)?
Check the owners of the views. Do you use owners when creating and deleting
the views?
Markus
"anonymous" <yadav.vk@mellonhris.com.sg> wrote in message
news:4253a253@forums
-1-dub...
> Hi,
>
> We are using SQL Anywhere 5.5.x and 6.x sometime we need to re-creating
> views so we drop them and create again, while dropping database gives
error
> that object does not exists and when we try to create them it says object
> already exists!!! May I know what could be the reason here?
>
> I know these version are no more suported but customer does not wants to
> upgrade database right now so until they decide to upgrade we need to
> support this.
>
> Regards,
>
>
| |
| anonymous 2005-04-07, 7:01 am |
| There is a PB program which do this job and this program is used from many
years. In this program it use Schema.ViewName, it works fine often but
sometime create this kind of problems. Even we can't find such view using
Sybase Central or iSQL. After rebuild of database we can create these views.
"Markus Hofer" <mh[(at)]smartsol.ch> wrote in message
news:4253b16e$1@foru
ms-1-dub...
> How do you delete and create the views (SQL statements)?
> Check the owners of the views. Do you use owners when creating and
deleting
> the views?
>
> Markus
>
> "anonymous" <yadav.vk@mellonhris.com.sg> wrote in message
> news:4253a253@forums
-1-dub...
> error
object[color=darkred
]
>
>
| |
|
| There is a PB program which do this job and this program is used from many
years. In this program it use Schema.ViewName, it works fine often but
sometime create this kind of problems. Even we can't find such view using
Sybase Central or iSQL. After rebuild of database we can create these views.
> "Markus Hofer" <mh[(at)]smartsol.ch> wrote in message
> news:4253b16e$1@foru
ms-1-dub...
> deleting
re- creating[color=darkr
ed]
> object
to[color=darkred]
>
>
|
|
|
|