Your comments

Is this really available on all databases that support it? I can't get it the show on  a PostgreSQL example, which has the SERIAL notation to support it.

When working in project that targets multiple database engines, the design needs to be created as a generic relational database model. This model can then be used with the SQL generators for the different target systems.

This also requires a module where the designer can model the data domains and there mapping to the target database.

When modelling and building databases that must execute on different database engines, this is a must.