SQL Server Identity Column

Ask for Help
1

I am just starting in Glide. I have an existing Azure SQL database that has several tables with Auto Incrementing Identity Columns as the Primary Key. When I try to attach those tables in Glide, it ask to define a Primary Key from the columns and the Identity Column is not listed. Does Glide support SQL Server Auto Incrementing Identity Columns?

Thanks.

2

Can you check this @NoCodeAndy ? Thank you.

3

I have the same issue. Was this resolved?

4

I never heard back from Glide and went in a different direction.

Scott

image681478.png

image584376.jpg

5

Ok thanks for letting me know. Hopefully they have a fix.

6

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;

1 Like