Table size and row count

My database is in TB with different schemas. I would like search in each schema following information:

  • Schema name
  • Table name
  • Table size
  • Rows count
  • Created date

Where table name contains: *.bak or dropped_* or *_drop