How to specify Check Constraint on Varchar Datatype column in SQLALchemy?

Question

Hi,

I am trying to specify this check constraint on a column via SQLAlchemy.

delete_flag char(1) not null CHECK(delete_flag in('Y','N')),

I am not able to figure out the syntax to achieve this. Any link, tutorial, advise will be of great help.

Thanks Tara Singh

Answer 1

Theres according chapter in the official documentation:

http://www.sqlalchemy.org/docs/metadata.html#check-constraint

http://www.sqlalchemy.org/docs/reference/sqlalchemy/schema.html#sqlalchemy.schema.CheckConstraint