 |
 |
Archives of the TeradataForum
Message Posted: Wed, 09 Nov 2005 @ 14:15:58 GMT
| Subj: | | Re: View column data type |
| |
| From: | | Mike Felts |
| | Using a prepared statement is the best way to get meta data about a table or view as it is not system dependent. That is, the same code
would work against any DBMS that supported prepared statements (i.e. most if not all of them). | |
| | For what it is worth, I don't think any version of Teradata populated data type details in dbc.columns (at least for not as long as I can
remember). | |
How does one go about utilizing a prepared query like this? Or is it something only the database can do?
I do have information in dbc.columns, but only for physical tables. I wasn't certain if your last paragraph above related to only views or to
the table at large. I would find it odd that dbc.columns didn't have the information for physical tables.
Mike
| |
