Skip to content

Instantly share code, notes, and snippets.

@emrodriguez

emrodriguez/ALTER TABLE.SQL

Last active July 31, 2022 16:45
Show Gist options
  • Save emrodriguez/178c05beeb8afa8b2c53eb3bd027f1ef to your computer and use it in GitHub Desktop.
Save emrodriguez/178c05beeb8afa8b2c53eb3bd027f1ef to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ALTER TABLE.SQL
ALTER TABLE TABLE_NAME
ADD NEW_COLUMN INTEGER REFERENCES TABLE_REFERENCE(ID_PRIMARY_KEY);
Raw
many to many sqlite.sql
CREATE TABLE "Material_PreSet" (
idMaterialPreSet INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
idMaterial INTEGER REFERENCES Material(idMaterial),
idPreSet INTEGER REFERENCES PreSet(idPreSet)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment