Obtener los campos de una tabla

SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('dbo.tabla')

SELECT * FROM nombre_base_de_datos.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'dbo.tabla'

fuente