How do I enter data when extending a table that already has data in it?

[KazukiM]

I want to extend the user table(sys_user) to create a user information table(my_app_user_info) dedicated to my application.

I know that when I add a record to the extended table, a record will also be automatically created in the original table
and user table also has a uniqueness constraint based on the user ID.

I think this is not able to create record to my_app_user_info for users who are already using this instance.

What should I do?

[Ankur Bawiskar]

@KazukiM 

that's the correct and how extending sys_user works.

It's the same behavior when User table is extended in CSM space.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @KazukiM 

Yes mate your understanding is correct here.

https://www.servicenow.com/community/in-other-news/how-does-the-magic-from-extend-table-work/ba-p/22...

[Mike Lynch]

I am assuming based on the info provided you are just trying to store additional data about users. A user "information" table should not extend the sys_user table - it should reference it. Make a foreign key (reference field) to the sys_user in your table. Extending is not the right approach.