Delete the table

[Gowtham Kodali]

hi all,

i have a requirement to delete a custom Table , before deleting the table what are precautions i need to take

what are best practice  i need to follow when deleting the table

thanks in advance

[Dr Atul G- LNG]

Hi @Gowtham Kodali 

If the tables has no data then no issues go n delete the table. 

[Dr Atul G- LNG]

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

[GlideFather]

Hi @Gowtham Kodali,

be sure that the table doesn't contain anything that you don't want to lose. So either backup, export or save the data/table records.

Then go to the sys_db_object table, it's table with all the tables:

https://yourinstance.service-now.com/nav_to.do?uri=sys_db_object_list.do

Once you are there, select between Delete All Records (only records are deleted and table stays) or Delete (both records and table will be erased)

 

There's this control mechanism to confirm the table deletion and prevent undesired data loss:

[yashkamde]

Hello @Gowtham Kodali ,

Refer below table, this ensures clean removal without breaking functionality or losing important information.

Sr No.	Best Practice	Why It Matters
1	Delete all records first	Prevents orphaned data and ensures clean removal.
2	Document the table's purpose & history	Provides traceability for audits and future reference.
3	Check update sets & versioning	Avoids accidental re-creation during deployments.
4	Use "Delete" option under System Definition > Tables	Ensures proper removal through ServiceNow UI.
5	Monitor system logs post-deletion	Detects errors or missing references quickly.

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