SNPI Story1 - delete table

[ashishgoyal]

Hi ,

I was doing SNPI Story1 and mistakenly created wrong HHD table, now i want to delte it . how can i do so, not finding any options. I am stuck and unable to validate the task as if i create another HHD table it will create another system names.

[GlideFather]

Hi @ashishgoyal,

in the All menu type "sys_db_object.list" and press enter, it will get you to a table that contains all the tables.

Locate the HHD that you want to delete and open it, there is a button to delete either All Table Records or the entire Table. When you delete the whole table, it requires you to type "delete" as confirmation before proceeding.

Let me know if that worked for you.

[Mohammed8]

Hi @ashishgoyal 

@GlideFather  approach is right and will work.

I will be just adding on how to navigate 

1) Go to System Definition -> Tables 

2) In Name search for your custom table

Here is the documentation link which explains thing that need to be taken care of before deleting table:

https://www.servicenow.com/docs/bundle/zurich-platform-administration/page/administer/table-administ... 

Regards,

Mohammed Zakir

[M Iftikhar]

Hi @ashishgoyal You can delete the table, Just follow these steps:

• Go to System Definition → Tables.
• Search for your HHD table
  
• Open the table record, and first click Delete All Records. A confirmation popup will appear where you need to type delete to proceed.
  
• This step is recommended so that any business logic (like reference cascades or delete rules) runs properly.
• Once all records are deleted, you’ll see the Delete button on the table record, click it and again popup will appear where you need to type delete again, and the table will be removed.

After that, you should be able to recreate the table and validate the task without issues.

Hope this helps!

If my response helped, please mark it as the accepted solution so others can benefit as well.