How to get DB Creation Date,User name and other stats in SS Cluster

#1

Hi,

I want to get Statistics of Database Creation date, Which user created the DB, Table creation date, Which commands run on particular DB?

Pls let me know how to get above details in SS Cluster by runnng commands in SS Studio GUI.

I have installed SS using Tarball on Linux with SS version: 8.0.9

#2

Try

use information_schema;
select * from distributed_databases;
select * from schemata;
select * from tables;

The user who created the table is available in the TABLES table.