Skip to main content
To homepage To homepage
Solved

Create Identity column

  • October 15, 2022
  • 2 replies
  • 134 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.

View original

    JTreadwell
    Employee
    Forum|alt.badge.img+5

    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
    • Contributor
    • October 18, 2022

    Thanks, I used that column and solved my problem 

    Reply


    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings