3 ms·
Why would you want to do these in a UI instead of scripting/automating them?
by needusername 12y ago
Why would you want to do these in a UI instead of scripting/automating them?
- coldtea 12y agoBecause. Plus the two things are not contradictory. You can do them in the GUi and get the resulting SQL / DDL code to automate them later.
- psychometry 12y agoBecause it's not a good use of time for one-off modifications. Plus, the GUI is nice for visualizing, so there's a decent chance you're spending a lot of time in there anyway.
- needusername 12y agoOne-off modifications, because development, qa and production schemas don't have to be in sync.
- psychometry 12y agoIt's possible to run a query to modify the contents of a database without changing the schema. You may already be familiar with the UPDATE statement, for instance. And not every database in existence is part of a larger stack. I don't care much about automating a task I'll only do once in a throwaway DB that exists only on my computer.