L' Eomot Inversé (2/3/2012)
so what is the correct case mixture? Presumably "geometry" going by Hugo's note, which seems to make SQL Server's type naming a bit inconsistent.
Yep, "geometry" (all lowercase) is correct.
I don't know why you think that is inconsistent. ALL data types have their official name in all lowercase:
SELECT name FROM sys.types WHERE name LIKE '%[A-Z]%' COLLATE Latin1_General_100_BIN2;
The only inconsistency is that for the true (non-CLR) system types, SQL Server allows mixed case even in case sensitive databases and on case sensitive instances, while it is not as forgiving for the CLR-implemented types (hierarchyid, gemoetry, geography).