Menu

document Function - INFORMATION_SCHEMA_COLUMNS

ema manu

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')