|
|
|
|
|
by rsaarsoo
1272 days ago
|
|
I think there are pros and cons to both approaches: - Explicitly spelling out the column names has the advantage that you can search your code base for that name and see where it's used. - When declaring a view which filters the rows in a table, using SELECT * would simplify maintenance, as you wouldn't need to update the view when new columns get added to the table. |
|