How to create schema & Databases in SQlite?


Hi @omprashad and welcome to the forum.

If you’re using SQLite, you can just leave the schema field blank and it will work (I just did a quick test myself).

2 Likes

@ScottF Thank You for quick response, but my question is can we create our own schema rather than use default schema.

@omprashad you can use every sql command that SQLite would support. You might want to consult the SQLite documentation about this.

https://sqlite.org/lang_naming.html

https://sqlite.org/lang_attach.html

2 Likes

@mlauber71 Thank You, dude i already tried these thing.

  • Create schema test;

Hi @omprashad , there is no notion of schema in SQLITE, at least not in the same way as in MSSQL or Snowflake.

Also, you said “I already tried these thing”, what “thing”? Things from the documentation? I doubt there is a “Create schema” syntax in the documentation, so I’m not sure what you are referring to there.

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.