Select to view content in your preferred language

Can't export to feature class called "Drop"

1362
4
05-03-2023 03:37 PM
Scoth
by
Occasional Contributor

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

 

Scoth_0-1683153441478.pngScoth_0-1683153441478.png

 

0 Kudos
4 Replies
JoshuaSharp-Heward
Frequent Contributor

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.

0 Kudos
BarryNorthey
Frequent Contributor

Looks like it is a SQL reserved word:

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

BarryNorthey_0-1683157390193.pngBarryNorthey_0-1683157390193.png

 

Robert_LeClair
Esri Esteemed Contributor

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.

0 Kudos
ChrisUnderwood
Esri Regular Contributor

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

0 Kudos