Skip to main content
To homepage To homepage
Solved

Create Identity column

  • October 15, 2022
  • 2 replies
  • 145 views
ignacio
Contributor
Forum|alt.badge.img+1

Hi all, 

I need to create an Identity column, How could I create it in TX?

Thanks

Ignacio

Best answer by JTreadwell

Hi Ignacio, thanks for posting.

The DW_ID is an identity column created automatically on every table. You could also use a supernatural key based on the primary key for a bit more customization.

    ignacio

    2 replies

    JTreadwell
    Employee
    Forum|alt.badge.img+5
    • JTreadwell
    • Employee
    • Answer
    • October 17, 2022

    Hi Ignacio, thanks for posting.

    The DW_ID is an identity column created automatically on every table. You could also use a supernatural key based on the primary key for a bit more customization.

    -Joseph Treadwell
    ignacio
    Contributor
    Forum|alt.badge.img+1
    • ignacio
    • Author
    • Contributor
    • October 18, 2022

    Thanks, I used that column and solved my problem 

    Terms and ConditionsCookie settingsAccessibility statement