Archives of the TeradataForum

Message Posted: Mon, 03 Feb 2014 @ 22:59:34 GMT

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

Preface: I am *not* an SQL programmer, just an occasional tinkerer, and so my SQL skills are not strong, but...

To my very SQL-inexperienced mind, that seems like kind of a bummer, no-win situation.

- If you explicitly list the columns you want, you might miss new ones that have been added to the table or run into errors if a column you specify has been deleted.

- If you use *, and columns ARE added or deleted, SEL * breaks.

So is there any way to create a view that captures all the columns of the base table, no matter if columns have been added or removed since the view was defined?

I know this is probably getting into some very basic SQL and table/view theory, so forgive me if it's a kind of silly question, but every little thing I learn helps me understand this better (and I have not had time for a real SQL class yet).

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