Toad World® Forums

How to quickly get "select <all columns>" from "select *"


This is handy and not very obvious, so I wanted to share.

Enter “select * from whatever”, and run it.
Click where I circled below, then do a CTRL+A, followed by CTRL+C.
You now have all column names in your clipboard. So remove the ‘*’ and paste them in.



This is really handy, John, thanks for sharing.

Another quick way to gen an all-column SELECT is to choose Generate->Select off the right-click menu for your desired table in the Schema Browser.