SQL Server : how to create table with columns name as schemaname.columnname

Question

I am trying to create the table using below codes but the column name do not show schema name.

Select customer as `tablename.customer`
From tablename

Also, I tried

Select customer as [tablename.customer]
From tablename

Any suggestions?

Thank you, KP

Please read through "how to ask a good question" and update your post accordingly - you've done half the work. — Shadab Siddiqui, Jul 24 '18 at 19:18
do you actually mean `create table` or just return values? Help us help you. — sniperd, Jul 24 '18 at 19:25
I assume, based on your tags, that you are working in Dremel (now Apache Drill). Is this correct? — Laughing Vergil, Jul 24 '18 at 19:31
You need to decide which DBMS you are working with. Without that detail this is an unanswerable question. — Sean Lange, Jul 24 '18 at 20:24

score 0 · Answer 1 · answered Jul 24 '18 at 19:36

0

Based on the assumption of Dremel / Drill, use a table alias on your queries, e.g.

Select t.customer as `tablename.customer`
From tablename t;

answered Jul 24 '18 at 19:36

Laughing Vergil

1 Answers1