Does metadata only refer to the description of the attributes in RDBMS?

Nope metadata refers to details on all of the below

  • Various objects like tables, views, procedures, users, jobs, constraints etc
  • The column information within objects as well as their extended properties
  • User permissions information
  • Job execution status, etc
  • Details on databases, their file groups, files etc

The above list is not exhaustive

So metadata generally means any information about entities that make a database including database itself