Column aliases...

[Ricardo Paz]

Hi list...

Is there any way to list wich column aliases belong to wich tables???


Thank's



XE SP 19.1 Update 5 Win2000 and MSSQL 7
Greetings.
S.E. Ricardo Paz Castanon
Systems Chief and CNC Admin.
Comercial de Herramientas S.a de C.v.

+52(81) 81-96-26-49
[email protected] <mailto:[email protected]>


<file:///C:\Documents and Settings\rpaz\Datos de programa\Microsoft\

 

[dhelsley]

select thobnm AS TableName, tdobnd AS AliasName
from qa7333.f98710 th, qa7333.f98711 td
where th.thobnm = td.tdobnm;

 

[Ricardo Paz]

I found the info on the f9860...

Thank's any way





XE SP 19.1 Update 5 Win2000 and MSSQL 7

Greetings.

S.E. Ricardo Paz Castanon

Systems Chief and CNC Admin.

Comercial de Herramientas S.a de C.v.


+52(81) 81-96-26-49

[email protected]

www.cohesa.com

 

[RAMMEDJR]

Check the F98711 "Table Columns" table with the UTB (Universal Table
Browser). Type the alias of the data item (field) into the TDOBND field of
the QBE line and hit Find. Check the TDOBNM column for the tables that
contains this data item (field).

Dave Rammer
Sheboygan County IS Dept

Xe U2 SP16 / Ent: HP-UX 11i / Oracle 8.1.7.3 / Appl: W2K
Citrix MetaFrame 1.8

From: rpaz [mailto:[email protected]]
Sent: Friday, February 21, 2003 12:48 PM
To: [email protected]
Subject: Column aliases...


Hi list...
Is there any way to list wich column aliases belong to wich tables???
Thank's
XE SP 19.1 Update 5 Win2000 and MSSQL 7
Greetings.
S.E. Ricardo Paz Castanon
Systems Chief and CNC Admin.
Comercial de Herramientas S.a de C.v.
+52(81) 81-96-26-49
[email protected] <mailto:[email protected]>
<file:///C:\Documents and Settings\rpaz\Datos de programa\Microsoft\
--------------------------
To view this thread, visit the JDEList forum at:
http://www.jdelist.com/ubb/showflat.php?Cat=&Board=OW&Number=50239
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

 

[dhelsley]

Re: RE: Column aliases...

So you wanted the table names? Not the aliases (columns)? Glad you found what you were looking for.