# How to create Identity for a column(S.No) from 1-1000

**URL:** <https://www.dynamicsuser.net/t/how-to-create-identity-for-a-column-s-no-from-1-1000/44734>\
**Category:** User Forum\
**Created:** [March 20, 2013, 9:23am UTC](https://www.dynamicsuser.net/t/how-to-create-identity-for-a-column-s-no-from-1-1000/44734 "2013-03-20T09:23:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manimaran](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@Manimaran](https://www.dynamicsuser.net/u/Manimaran)\
**Post date:** [March 20, 2013, 9:23am UTC](https://www.dynamicsuser.net/t/how-to-create-identity-for-a-column-s-no-from-1-1000/44734/1 "2013-03-20T09:23:09Z")

</div>

i want to create the identity S.no for my table like in sql

create table tab\_name (S.no int identity(1,1)) likewise i want to do in ax how can i achieve this

---

<div class="post-metadata">

**Author:** ![Harish](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@Harish](https://www.dynamicsuser.net/u/Harish)\
**Post date:** [March 20, 2013, 9:44am UTC](https://www.dynamicsuser.net/t/how-to-create-identity-for-a-column-s-no-from-1-1000/44734/2 "2013-03-20T09:44:47Z")

</div>

Hello,

You can use number sequence functionality in AX. More details on number sequence could be found in this forum.
