Exporting from SDE Feature Class to Shapefile, Field Name Issue

[BenVan_Kesteren1]

Hey All, 

I have a feature class that resides within my SDE, I have added this to an ArcMap document, and created a join to a SQL Query Layer, the Table view looks good, showing field names, not alias.

So I then run the Feature Class to Feature Class tool to convert it to a shapefile.

I then take a look at the resultant shapefile, and I note that the field names have been exported, not retaining the Alias as viewed within the MXD.

What I am wanting is to retain the field alias (or as much as possible with the naming constraints of a shapefile). Any ideas on how I can achieve this?

Here is the original Feature Class properties:

I think create a join to my SQL Query Layer:

I then run Feature Class to Feature Class tool, and this is the name of the output fields:

[DanPatterson_Retired · Accepted solution]

Do you try the field mapping option ?

[BenVan_Kesteren1]

Excellent, exactly what I require. I previously thought field mapping was for changing field types from one to another, I didn't realise that we could rename at the same time.

Thats fantastic, exactly what I required.

Cheers

[NeilAyres]

There are a lot of restrictions in the 30(?) year old shapefile format. One is the width of the column headers, which I think is 10 characters.

Don't think that alias' are supported at all.

ESRI Shapefile / DBF 

geotools - How to bypass 10 character limit of field name in ShapeFiles? - Geographic Information Sy...