|
Home > Archive > IQ Server > February 2006 > dba.dba.dba
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hello, All!
select count(*) from dba.dba.dba.MyTable
Why does it work?
With best regards, Alsin.
| |
| Eugene Korolkov 2006-02-28, 8:34 pm |
| Looks like question from some test. Why not ?
<server name>.<db name>.<db owner>.<table name> is a complete
specification for the table name (at least at ASE)
HTH,
Eugene
Alsin wrote:
>Hello, All!
>
>select count(*) from dba.dba.dba.MyTable
>Why does it work?
>
>With best regards, Alsin.
>
>
>
>
| |
|
| Yep, but server and database have different names, not 'dba'. But this query
works on Sybase IQ 12.5
I think IQ just ignores server and database name in this case.
> Looks like question from some test. Why not ?
> <server name>.<db name>.<db owner>.<table name> is a complete
> specification for the table name (at least at ASE)
> HTH,
> Eugene
> Alsin wrote:
> Hello, All!
> select count(*) from dba.dba.dba.MyTable
> Why does it work?
> With best regards, Alsin.
|
|
|
|
|