I want to implement a quality to check audit column availability in table creation statement, i am able to do it using regex , but i want to check for specific column data types along with nullability

Akash · November 30, 2023, 4:15pm

I have this below requirement where all 4 below column must be available in create table statement with these data type along with nullability option.
CREATEDBY character varying (50) NOT NULL,
CREATEDDTM TIMESTAMP(6) NOT NULL,
MODIFIEDBY character varying (50)
LASTMODIFIEDDTM TIMESTAMP(6)

Provide me regex which i can use to check for all these columns using quality check in liquibase

Topic		Replies	Views
Nullable TIMESTAMP columns in MySQL are not nullable. Liquibase Development	3	865	July 15, 2010
DB-specific conditional column types General Discussion	1	1525	December 15, 2010
An alternative way to use Liquibase General Discussion	3	776	February 24, 2012
Column "createdtime" is of type timestamp without time zone but expression is of type character varying Liquibase Development	3	13528	February 7, 2022
SQLite updateSQL AddColumn General Discussion	2	634	June 7, 2021

I want to implement a quality to check audit column availability in table creation statement, i am able to do it using regex , but i want to check for specific column data types along with nullability

Related Topics