On 2019-02-19 12:23, Jiří Činčura wrote:
Hi *,
can I drop identity specification from the column on FB3? I've found
only CORE-5431, but that's only for 4.0.
You can't in Firebird 3. See the release notes on
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-identity,
specifically:
"""
An identity column cannot be altered to become a regular column. The
reverse is also true.
"""
Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel