CODEWITHSUNDEEP
sql
Arun Mohan
Arun Mohan

Reputation: 347

column Aliases is turning lowercase but i want it as i define

I am creating columns naming them using Aliases as how i want, but no matter what case i use, finally i see only lowercase headers in the table. how can i get what i want.

CREATE table schemaName.tablename AS
SELECT   action
FROM     schemaName.differentTableName AS "Upper.Action"

i currently get

action
data1
data2
data3

what i want is

Action
data1
data2
data3

Upvotes: 1

Views: 2174

Answers (1)

user330315
user330315

Reputation:

Your SELECT statements assign an alias to the table, not the column. You need to use a quoted column alias

create table schemaName.tablename as
select action as "Action" 
from schemaName.differentTableName;

Upvotes: 3

Related Questions