Hi,
I am needing to check the size of multiple databases/tables in SQL, I am using (sp_spaceused [tablename]) however as I have over 100 tables, looking to see if i can run this query via alteryx. Basically looking to see if Alteryx can run queries on a db to get information about the tables not the data itself to then store somewhere else
Thanks.
Many DBs have a metadata table which would contain information on other tables. Start by identifying that table.