[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Tool to easily view and tweak data in a DB table... kind of like editing a spreadsheet

I have some small tables in a DB that would be nice to be able to tweak more or less manually... without having to write an SQL statement manually every time I want to update a single thing.

Are there any tools that load a DB table for display and I could edit individual cells easily by say, right clicking the cell, saying "change value" and then being given a box to enter the new value, and it will write and execute the sql for me?  Or something similar?
0
Xetroximyn
Asked:
Xetroximyn
1 Solution
 
Jerry MillerCommented:
SQL Server Management Studio allows you to right-click on a table, choose design. From there you can edit the columns as long as the data integrity doesn't change. For example you change varchar(10) to varchar(5) and you have existing data longer than 5. It will warn you that you are truncating some data.

http://www.microsoft.com/en-us/download/details.aspx?id=7593
0
 
Chris StanyonCommented:
0
 
XetroximynAuthor Commented:
Will these work with DB2?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Chris StanyonCommented:
Probably not.

You posted this in the MSSQL and MySQL Zones, so the links provided are specifically for those 2
0
 
LowfatspreadCommented:
have you considered MS Access and using table links... that would allow quick and dirty ability to display and change the data values....

or di you mean you want to be able to change the table structures?
0
 
Scott PletcherSenior DBACommented:
I know a lot of people that use Toad for that.  It's one interface works for many different dbs.  It used to be free but know I think it may charge.  But you can still get a free trial at the very least.
0
 
Jerry MillerCommented:
I actually prefer to write update statements when doing object updates. This way I can save it so I know exactly what was changed, when, and who did it. But then I am a bit of a control freak and want to be able to easily reverse and changes.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now