SQL Server Identity Column

Glide came back with the following workaround. Add a constraint to another column which Glide app can use as the rowID.

ALTER TABLE TABLENAME ADD CONSTRAINT DF_rowID DEFAULT (CONVERT(varchar(255), NEWID())) FOR rowID;