This format makes it clear what each query does. Let me know if you need any modifications! ??

SELECT name, create_date FROM sys.databases

SELECT * FROM information_schema.schemata

select * from sys.tables

select * from sys.procedures

select * from sys.all_views

select * from sys.all_columns

SELECT DB_NAME(database_id) AS database_name, COUNT(*) AS query_count FROM sys.dm_exec_requests GROUP BY database_id ORDER BY query_count DESC;