Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
Read the documentation for SQLite CREATE TABLE clauses, not questions about Netbeans JavaDB. In particular, if you expand column-def and column-constraint you'll see the correct syntax for what yo...
Answer
#1: Initial revision
Read [the documentation for SQLite CREATE TABLE clauses](https://www.sqlite.org/lang_createtable.html), not questions about Netbeans JavaDB. In particular, if you expand `column-def` and `column-constraint` you'll see the correct syntax for what you're trying to do. However, note also that [it's not recommended unless "strictly needed"](https://www.sqlite.org/autoinc.html).