I am having a query shortcut that is generating create table in SQL Server Management Studio 2016. This works fine when I am not trying to select `schema.table`, but once I am trying to select such object I am getting error Incorrect syntax near `'.'`.

My query shortcut looks like:

    exec sp_executesql 'huge sql oneliner', N'@table_name SYSNAME', @table_name =

Any idea how I can pass objects like that to the query shortcut?

The only workaround I kind of found is to wrap the table name with the single quotes, which is a bit annoying.