3

I can't figure out the syntax to query a feature class by GlobalID because the GlobalID is not a string, float, etc.

What is the syntax to query by GlobalID in SQL using ArcGIS Pro?

SELECT * FROM TABLE WHERE GLOBALID = {31595CF4-D5C7-49A4-85D2-C245BEBC009F}
0

1 Answer 1

3

You actually treat it like a string.

Note the selection Query statement made in ArcGIS Pro:

select by attributes

If you view the SQL statement, you see it wraps the value in single quotes:

SQL statement

Update your SQL to:

SELECT * FROM TABLE WHERE GLOBALID = '{31595CF4-D5C7-49A4-85D2-C245BEBC009F}'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.