On Sat, 4 Aug 2018 21:40:53 -0400, Stephen Chrzanowski <pontia...@gmail.com> wrote:
> I'm making a small database for a game, and a bunch of the tables follow > the same kind of naming convention due to normalization, like > > {Name_Of_Information}s > {Name_Of_Information}ID as Integer > {Name_Of_Information}Name as Char > > So for example: > > Resources > ResourceID as Integer > ResourceName as Integer > > (Plural name on the table name, singulars on the field names) > > Would there be a way within SQLite via CTE or whatever other magic there > is, to create tables based on this structure, and setup the PK? I guess would use good old m4 for that. Or awk. [...] -- Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users