How do I find table/field names and aliases using SQL

[pcawdron]

How do I find table/field names and aliases using SQL regardless of the platform used?<br><br>SQL server has the catalog procedure sp-database, sp_tab;es and sp_columns, while the AS400 DB2 has the more obscure system tables QSYS.QADBIFLD and QSYS.QADBXREF.&nbsp;&nbsp;<br><br>Is there a universal standard for SQL database schema???<br><br>Thanks for your help with this

 

[calahans]

No universal standard for schemas. The SQL language is standard but the schema is an implementation specific thing therefore each of the vendors have there own system tables and master database etc... <p>Cal<br><a href=mailto: > </a><br><a href= > </a><br>

 

[pcawdron]

I thought as much, thanks for your confirmation of this.<br><br><font color=red><b><i><u>Are there any good sites listing schema standards for various SQL implimentations? </font></b></i></u> For example, Oracle's simple enough, but what about Ingress, Informix, etc.<br><br>Any ideas?

 

[bigscouse]

If you want a good ingres techy site try: -<br><br><A HREF="

http://munkora.cs.mu.os.au/~yuan/Ingres/ingres.html"

TARGET="_new">

http://munkora.cs.mu.os.au/~yuan/Ingres/ingres.html</A><br>

<p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>