Why is using ‘*’ to build a view bad?

by

I don’t think there’s much in software that is “just bad”, but there’s plenty of stuff that is misused in bad ways 🙂

The example you give is a reason why * might not give you what you expect, and I think there are others. For example, if the underlying tables change, maybe columns are added or removed, a view that uses * will continue to be valid, but might break any applications that use it. If your view had named the columns explicitly then there was more chance that someone would spot the problem when making the schema change.

On the other hand, you might actually want your view to blithely
accept all changes to the underlying tables, in which case a * would
be just what you want.

Update: I don’t know if the OP had a specific database vendor in mind, but it is now clear that my last remark does not hold true for all types. I am indebted to user12861 and Jonny Leeds for pointing this out, and sorry it’s taken over 6 years for me to edit my answer.

More Related Contents:

  1. What is the difference between Views and Materialized Views in Oracle?
  2. What are views good for?
  3. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  4. adding primary key to sql view
  5. Difference between View and table in sql
  6. What is the difference between a stored procedure and a view?
  7. Row Rank in a MySQL View
  8. Why isn’t row level security enabled for Postgres views?
  9. SQL Combine two rows into one
  10. SQL Server Subquery a
  11. SET NOCOUNT ON usage
  12. Oracle: how to UPSERT (update or insert into a table?)
  13. How can I get column names from a table in SQL Server?
  14. What exactly do quotation marks around the table name do?
  15. How can I get column names from a table in Oracle?
  16. What mysql database tables and relationships would support a Q&A survey with conditional questions? [closed]
  17. sqlite database default time value ‘now’
  18. MySQL remove duplicates from big database quick
  19. Storing sex (gender) in database
  20. EXISTS vs JOIN and use of EXISTS clause
  21. SQL count(*) performance
  22. How much disk-space is needed to store a NULL value using postgresql DB?
  23. Get everything after and before certain character in SQL Server
  24. Match only entire words with LIKE?
  25. UNIX_TIMESTAMP in SQL Server
  26. Retrieve column names and types of a stored procedure? [duplicate]
  27. PostgreSQL 9.3: Dynamic pivot table
  28. ORA-01861: literal does not match format string
  29. Backup SQL Schema Only?
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment