Seed Script

noun

say it: “SEED skript” /siːd skrɪpt/

A SQL script that fills a database with the rows every copy needs, written so it can run again safely.

What is Seed Script?

Seed Script — A SQL script that puts in the rows every copy of the database needs, such as the list of categories. It checks before inserting, so running it twice doesn't add duplicates.

IF NOT EXISTS (SELECT 1 FROM Categories WHERE CategoryName = 'Tea')
    INSERT INTO Categories (CategoryName) VALUES ('Tea');

In a sentence

  • “The seed script adds the six categories to every new copy of the database.”

Level: Apprentice · More Database terms at this level

Updated