How to identify a colocated database from the rest

[Question posted by a user on YugabyteDB Community Slack ]

How to identify a colocated database from the rest?

One way to identify a colocated table in YugabyteDB is to look at the yb-master UI page ( http://<yb-master-ip>:7000/tables ). All colocated databases will have a system table entry with the name ( <id>.colocated.parent.tablename ).

You can also use the yb-admin utility like below:

./bin/yb-admin --master_addresses <master_addresses> list_tables_with_db_types | grep '\.colocated\.parent\.tablename