INFORMATION_SCHEMA_COLUMNS
it's the same of Sql view, but could extract the informations from different db without dynamic query
example:
select * from [dbo].[INFORMATION_SCHEMA_COLUMNS]('test')