thank you all very much. I ended up with:

declare @cmd nvarchar(300)

declare @prop nvarchar(20), @con nvarchar(20), @seg nvarchar

I still get "Invalid column name 'dtproperties'."

Here is my code exactly:

declare @cmd nvarchar(200)

 set @cmd = N'SELECT TABLE_NAME, COLUMN_NAME FROM BW_P3.information_schema.COLUMNS

    WHERE TABLE_NAME <> "dtproperties" ORDER BY TABLE_NAME'

 exec sp_executesql @cmd

Thank you, that part works now, but a part I had working, now doesn't.

SELECT TABLE_NAME, COLUMN_Name FROM database.information_schema.COLUMNS WHERE TABLE_NAME <> dtproperties ORDER BY TABLE_NAME

This worked when I put...