# SQL Server Identity Column

**URL:** <https://community.glideapps.com/t/sql-server-identity-column/71966>\
**Category:** Ask for Help\
**Created:** [March 23, 2024, 6:26pm UTC](https://community.glideapps.com/t/sql-server-identity-column/71966 "2024-03-23T18:26:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![SRW](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@SRW](https://community.glideapps.com/u/SRW)\
**Post date:** [March 23, 2024, 6:26pm UTC](https://community.glideapps.com/t/sql-server-identity-column/71966/1 "2024-03-23T18:26:58Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 24, 2024, 12:30am UTC](https://community.glideapps.com/t/sql-server-identity-column/71966/2 "2024-03-24T00:30:42Z")

</div>

Can you check this @NoCodeAndy ? Thank you.

---

<div class="post-metadata">

**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\
**Post date:** [May 9, 2024, 6:06pm UTC](https://community.glideapps.com/t/sql-server-identity-column/71966/3 "2024-05-09T18:06:25Z")

</div>

I have the same issue. Was this resolved?

---

<div class="post-metadata">

**Author:** ![SRW](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@SRW](https://community.glideapps.com/u/SRW)\
**Post date:** [May 9, 2024, 6:48pm UTC](https://community.glideapps.com/t/sql-server-identity-column/71966/4 "2024-05-09T18:48:36Z")

</div>

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

Scott

![image681478.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/edbf7a5f894049bc978c799cd57554cc9e8b6d54.png)

![image584376.jpg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/285265cc941a0b9f4a8a778d2af8b3513989528c.jpeg)

---

<div class="post-metadata">

**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\
**Post date:** [May 9, 2024, 7:08pm UTC](https://community.glideapps.com/t/sql-server-identity-column/71966/5 "2024-05-09T19:08:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\
**Post date:** [May 17, 2024, 9:00am UTC](https://community.glideapps.com/t/sql-server-identity-column/71966/6 "2024-05-17T09:00:32Z")

</div>

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_;