Collection type variable is not found in the active table

[Manjula Saravan]

Collection type field is not there in the active table(u_site_watcher_locations) . Any suggestions ? Please find the below screen shots. The table structure  It shows as an extension of the base 'cmdb' table with missing fields. my overall goal here is to safely remove this table [inactivation or deletion] as it is not used or needed.

[James Chun]

Hi @Manjula Saravan,

Have you tried the following steps to delete your custom table?

1. Navigate to All > System Definition > Tables.
2. Open the table (u_site_watcher_locations) to delete.
3. Select Delete All Records
4. Select Delete.
5. In the confirmation dialog box, enter delete and click OK.

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

Cheers

[Manjula Saravan]

@James Chun Can you please sugesst why the collection field is missing ?

[Ankur Bawiskar]

@Manjula Saravan 

strange

I don't think it should have any impact on deletion of table

Delete all records and then delete the table safely

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

[Manjula Saravan]

@Ankur Bawiskar  Can you please suggest me why the collection field type is missing ??