With SQL Prompt, you can expand SELECT * and SELECT table.* statements so that they list all of the columns that exist in the referenced tables.

To expand all wildcards in a SQL script:

1. Open the script you want to modify in a SQL Server Management Studio query window.
2. Ensure you are connected to the SQL Server and database that contains the objects referenced in the SELECT statements.
3. If required, select the portion of SQL that contains the SELECT statements that you want to expand. If you do not select any SQL, all SELECT statements in the script are expanded.
4. On the SQL Prompt menu, click Expand Wildcards.

You can undo the changes to the script using the standard SQL Server Management Studio Undo features.

To keep the changes, save the script.