Step 2: System Catalog Scripts

Using the System Catalog Views

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/object-catalog-views-transact-sql

create the SQL Scripts for the following views:

1. vw_TableNoIndexes: a. Description: Return all user tables with no clustered/ nonclustered Indexes.

b. Columns: name, create_date

2. vw_ProjectIdTables: a. Description: Return all the user tables which contain the column projectId

b. Columns: name, create_date

3. vw_Last7Obj: a. Description: All the objects that have been modified in the last 7 days

b. Columns: name, modify_date

4. vw_ProjectProcs: a. Description: The SQL logic (definition) from the stored procedures which have Project in their name

b. Columns: name, definition, create_date

NOTE: Please make sure you use the EXACT columns listed above for these views.

For more info: https://www.chegg.com/homework-help/questions-and-answers/step-1-create-table-audits-via-triggers-system-must-log-insertion-deletion-updates-followi-q30331335

On the post in this link, step 1 was answered but step 2 and 3 were not.