Creating/editing tables

shane_holland
Mega Contributor

I must be missing something here that is potentially obvious.

 

Under System Definition, the only option I have for anything relating to "tables" is the Tables & Columns module. In here, you can add a new table but I can find no way to edit the table and enter data into it. The only buttons that display are "Schema Map" and "Delete All Records". Where can I define and edit a table?

1 ACCEPTED SOLUTION

Shane,



That depends on whether or not you created an application / module when you created the table.


If you created an application/module it will appear in the navigator for you to create new records in the table.
If you did not, you can actually open the table from the Tables & Columns module OR you can type the name of the table in the navigation search as follows: u_tablename.list and it will open the table


View solution in original post

6 REPLIES 6

or use u_tablename.do to open the form


jesusemelendezm
Mega Guru

Certainly you can edit the content of a table through the list view calling the table from the navigator search "tablename.list" however I wonder, Is It possible to edit the table from a different view? I am looking for a view type phpMyAdmin - I used to administer a web based system in the past, and It was very handy to edit the rows of a table or any MySQL database object through this web database interface. What's something similar within ServiceNow?  



Thank you.