topic Can't export to feature class called "Drop" in ArcGIS Pro Questions

Can't export to feature class called "Drop"

Scoth — Wed, 03 May 2023 22:37:59 GMT

Pretty self explanatory really. Just can't do it. Got an error saying "Invalid Characters". Is this some database issue behind the scenes?

Re: Can't export to feature class called "Drop"

JoshuaSharp-Heward — Wed, 03 May 2023 23:43:16 GMT

Couldn't find any documentation on it but drop is basically "delete" in sql (https://www.w3schools.com/sql/sql_drop_table.asp) so I suspect that's why it's considered invalid. I can confirm I can't export a 'drop' feature class either, it'll work if you add a suffix though.

Re: Can't export to feature class called "Drop"

BarryNorthey — Wed, 03 May 2023 23:43:58 GMT

Looks like it is a SQL reserved word:

https://support.microsoft.com/en-us/office/sql-reserved-words-b899948b-0e1c-4b56-9622-a03f8f07cfc8

Re: Can't export to feature class called "Drop"

Robert_LeClair — Thu, 04 May 2023 12:47:31 GMT

And if you try to create a fGDB Feature Class called Drop, it says "name cannot be a keyword" for the error - so it's a reserved word as well in a fGDB too.

Re: Can't export to feature class called "Drop"

ChrisUnderwood — Thu, 04 May 2023 14:21:31 GMT

And this Esri blog article details the different Reserved Words that apply in different circumstances.

https://community.esri.com/t5/esri-technical-support-blog/words-by-reservation-only/ba-p/898664