Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 15:32:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Dieter's comments are (as always) right on. I might add that, you should also consider NOT using the SELECT * FROM DB.TABLE; syntax as this will cause a lot of extra effort and time when developers/users try to figure out what is in the view, etc. It's easy for a DBA to create a facility to generate those but all the time and effort is not here - but in the access and use of these objects! If you are a DBA have influence on them, don't let them take the easy road - the users (ETL developers, etc.) will suffer in the end.

I would suggest that you always use the following convention for clarity and ease of use, etc.

     REPLACE VIEW .
     (
             .
             column list
             .
     )
     AS
     SELECT
             .
             column_list
             .
     FROM
             .
     etc.

Providing this format gives potential users a,l the info they might need without doing further searches to find out what is in * and what order they are, etc.

But again - just the world from where I sit;-)

JK

	<Prev	Next>		<<First	<Prev	Next>	Last>>