PASS Summit 2027: North America and Europe|Register now
SQL Prompt (44)
SQL Code Analysis (44)
All databases
All levels

SQL Prompt logo

The Sins of SELECT * (BP005)

If Prompt warns you of use of the asterisk, or 'star' (*), in SELECT statements, consider replacing it with an explicit column list. It will prevent unnecessary network load and query performance problems, and avoid problems if the column order changes, when inserting into a table. Read more