R
Railway•8mo ago
vienna1981

database - any way to edit tables?

I have a problem with my app and suspect it is down to a table within my database and how I have configured the columns. However, there does not seem to be any way to inspect my table columns after I set them up, or to edit or even delete the table and start again. Is the only option to delete my entire database and create a new one in its place?
7 Replies
Percy
Percy•8mo ago
Project ID: N/A
Fragly
Fragly•8mo ago
Yea, just go to the railway dashboard, go to your database, right click and then click "Delete Service" railway also lets you inspect tables on there
vienna1981
vienna1981•8mo ago
sorry do you mean i have to delete the database ('delete service')? i couldnt find any way to inspect the tables otherwise, and assume if i delete service it will remove the database and all tables within
Fragly
Fragly•8mo ago
Oh my bad, I just woke up and misread, thought you asked how to delete a database, man I really should just get up and make some coffee 😭 yea deleting it is probably not necessary, there's likely a way to solve this without deletion but I'm too inexperienced with databases to help there, my bad
vienna1981
vienna1981•8mo ago
i cannot see anything in documentation and from playing around on screen cannot see any button that could do it
MantisInABox
MantisInABox•8mo ago
@vienna1981 it's best to use an actual app like DBeaver, DataGrip, MySQL Workbench or PGAdmin4, for manipulating and viewing db data.. the web UI is lacking in many areas
vienna1981
vienna1981•8mo ago
thanks! i deleted and redid my databse and it works ok now. I will try and use the other database app i used previosuly, i am just trying my app out at first