I'm looking at some Teradata SQL (without manuals).

All tables in the SQL are qualified with a prefix :

prefix.tablename

In Teradata, does this prefix refer to a database?

Thanks in anticipation :-)

nochance (AT) youmustbejoking (DOT) com says...


Are you sure that what you're looking at isn't


tablename.fieldname?


Paul...

--

plinehan x__AT__x yahoo x__DOT__x com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

Yes, definitely.

"Paul" <paul (AT) not (DOT) a.chance.ie> wrote

nochance (AT) youmustbejoking (DOT) com says...


OK then, you're basically asking a company specific question - why not
go to their site and look at their user groups - maybe somebody there
can help you out?


Paul...


--

plinehan x__AT__x yahoo x__DOT__x com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.

Paul <paul (AT) not (DOT) a.chance.ie> wrote

in a SQL context, that "prefix" is likely the schema name. Objects may
be qualified by the ID of it's containing object, so you can even have
more than one period in a name, for example referring to column
LOGIN_NAME in table ACCOUNTS in the SYSTEM schema looks like this:
SYSTEM.ACCOUNTS.LOGIN_NAME

So it's not necessarily company specific.

HTH,
Ed

Many thanks for all your help and tips guys

"Strangiato" <nochance (AT) youmustbejoking (DOT) com> wrote