How do I delete a table?

lzeke
Giga Contributor

I created a couple of tables on Fuji (patch2) and it seems there is no way to delete them. In "Tables" there is no Delete on the selected rows and in Dictionary I can wipe out some of the field records (and the table record itself), but can't delete the sys columns of these tables. This should be easy to do - what am I missing?

1 ACCEPTED SOLUTION

ProbirDas
Tera Expert

Are you following the below steps?



1. Navigate to System Definition > Tables.


2. Open the table to delete.


3. [Recommended] Click Delete All Records.


Deleting all records before deleting the table ensures that the business logic is properly executed (for example, reference cascade rules or other delete business rules). If you do not delete all records from the table first, then you must manually fix any other records or tables that are impacted by the table deletion.


4. Click Delete.


5. In the confirmation dialog box, enter delete and click OK.


The table and all items that reference the table are deleted, including:


  • Choice list items
  • Forms, form sections, lists, and related lists
  • Reports and gauges
  • Reference fields that reference the table
  • Access controls

View solution in original post

8 REPLIES 8

tony_barratt
ServiceNow Employee
ServiceNow Employee

Hi Laszlo,



I think closing the thread means marking the question as answered.


Also you can mark one or more replies as helpful - or like an individual reply.



Best Regards



Tony


Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

HI Laszlo Zeke



Please go through the below wiki link for more info on how to delete a table.


http://wiki.servicenow.com/index.php?title=Deleting_a_Table#gsc.tab=0



Please let me know if you are blocked.


lzeke
Giga Contributor

Thanks, Tony.


B_SAI REVANTH
Tera Contributor

open your table which you wanted to delete
Top right you could find delete button

A popup window appears.... Type delete and hit enter

thats it!
Table will be deleted