From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Ad hoc scripts for schema changes
From the course: Advanced SQL for Application Development
Ad hoc scripts for schema changes
- [Narrator] Now, one way of dealing with database schema changes and reference state of changes and bulk data loads is to write ad hoc scripts and run them manually. So let's take a look at what we can expect if that's the approach were going to take. Now, when we start with a database and a database definition, we're working with an initial set of data definition commands or DDL commands. When we're modifying those, we typically have a set of changes in a single script or a set of scripts that we execute as a unit. So all of those changes have to take effect or none of them have to take effect. Now, the kinds of schema changes we typically make when we're writing our ad hoc scripts are things like adding new tables, adding new tables and reference data, maybe dropping or adding columns, adding or dropping constraints. And there are other things we may do but these are some of the most common…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.