njtynhj

I am wondering if it is somehow possible to assign aliases/nicknames/common names to columns which have technical names rather than "easy to read"-names.

Say I have a table, where the columnnames are something like "CD12xxx" and I want to translate that into something readable:

Can this only be achieved by creating a view and "renaming" all columns with something like [CD12001] AS Customer_ID - or is there a nice way of doing this?

In Teradata I have seen something similar at some point, just wondering if it is possible in SQL-Server?

I believe it is SQL-Server 2016 my company is running.

Thanks.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.