How do I change column headers on a return value?

Question

I am trying to return everything in my table but I want to change the column headings ONLY when it gets returned.

SELECT * FROM d_cds 

That returns all the values from the table under the original column headings. How would I display them with different headings?

Answer 1

SELECT yourColumn as NameYouWant FROM d_cds