SQL Server Field Name Length Too Long

Question

I  am connecting to a SQL Server database that has field names greater than 31 characters.

Pretty much any geoprocessing tool fails on a SQL Server table that has field names this long as it is an ArcMap limitation.

Anyone know a command that will DUPLICATE the table without causing an error? Possibly by copying and then altering the field name. ALSO I need to use model builder so I can't manipulate/export in ArcMap first.

GregWhite2 · Answer

It doesn't work in this case because the table doesn't have a unique row identifier and the geoprocessing command is not letting me create one from within the SQL window SELECT statement. 
 I will persue some other avenue - thanks again!

GregWhite2 · Answer

I will try the query layer and see if that works!

GregWhite2 · Answer

Thanks for the tip, that maybe the solution. Yeah ArcCatalog kind of crashes when clicking on the table.