Table Creation

[prernasalun]

Hi Community

I want to learn in-depth knowledge about table creation. Where can I learn?

[Joe Wong]

Hi there,

Table creation I think is something you can easily learn, but extremely hard to master.  Depending on what you want to do with your table, how you want it the inherent with other table or even the core tables.  Then there is the side of reporting on the table and Database view (joints) with other tables.

Depending on your starting knowledge of database tables, if you are comfortable to SQL tables, you might be able to start off with getting a  PDI (personal development instance) from ServiceNow for free and start playing around with it.  Getting yourself comfortable is the table layout, how to create new table and how they interact with other tables.

Do know this, everything on ServiceNow is stored in a table somewhere.  So needing to know all the tables and what they do is like saying learning all the ins and outs of ServiceNow, something that can only come in time using ServiceNow and not by reading some online manual.

Hope this helps.

Joe

[Dr Atul G- LNG]

Hi @prernasalun 

https://youtu.be/_AsUlE2oJbs

https://youtu.be/ozycaTWFQvQ

https://www.servicenow.com/community/developer-articles/understanding-tables-in-servicenow-a-complet...

https://developer.servicenow.com/dev.do#!/learn/courses/australia/app_store_learnv2_aescreateappfrom...

Check the below service-now official product documentation links.
https://www.servicenow.com/docs/r/platform-administration/table-administration-and-data-management/t...

https://www.servicenow.com/docs/r/platform-administration/table-administration-and-data-management/t...

[yashkamde]

Hello @prernasalun ,

Refer this for detailed understanding :

Understanding Tables in ServiceNow – A Complete Guide 

If my response helped mark as helpful and accept the solution.

[harshbhushan]

Hi @prernasalun,

Refer to this Documentation from the Servicenow:
Reader • Docs | ServiceNow

Parallelly I will suggest you can do Hands-on Practice with a PDI because Table configuration is a skill which is mastered by breaking and building things by self only. You just need to Request a free Personal Developer Instance (PDI) at the ServiceNow Developer Portal. Navigate to System Definition > Tables to build custom structures, configure auto-numbering, and inspect how the system automatically provisions background CRUD Access Control Lists (ACLs).Type sys_db_object.list in your navigation bar to explore the internal "Table of Tables" that handles platform metadata.

Refer to this video from one of our community member:
https://youtu.be/nFBqQCjGjbg?si=MZ454KPRMPcNHltW


Thanks and Regards,
Harsh Bhushan