SQL Server SP - retrive DB information (Schema)

Hi I have a SQL Server Stored procedure: - I need you to update it with a few changes - and to add db schema information in 2 new tables Current output is a list of tables with -Table name -Number of rows -Reserved size -Data size -Index size -Unused size It is running only for current db New requirements What I need - Modify current stored procedure -Run the SP for ALL databases in the server -ADD a new field with DB name -SAVE output to a table (keeping history) -ADD a new timestamp field (date+hour when sp starts) -REMOVE “KB” from OUTPUT so it is stored in numeric format NEW TABLES: New SP code to retrieve NEW information for all db in the server, keeping the history (when we run, it will add a new set of records): Add a new table with table information, fields: -DB name -Table name -Index name -Index type -Unique (true/false) -A field with all "index key" column separated by “,” -A field with all "included columns" separated by “,” -Collation -All properties in Fragmentation section -Page fullness -Total fragmentation -Average row size -Depth -Add a timestamp field (date+hour when sp starts) Add a new table with field information -DB name -Table name or view name -Object type (table or view) -Field name -Field data type -Nulls allowed or not -Add a timestamp field (date+hour when sp starts) Thanks