SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'DIM_VENDING_MATERIALS'
sp_columns [tablename]