Dynamic schema, table and column names in SQL Server queries as a gateway to functional programming with R

I’m looking into creating some functions to make it easier to carry out quality checks on our database tables. I’m using SQL Server, where tables are referred to in a [database].[schema].[tablename] format, although you can forgo some of this by using the USE statement -