Cacher is the code snippet organizer for pro developers

select ORDINAL_POSITION, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE
from CRDMPointOfSale.INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 'CRDM_ItemDiscount'
and TABLE_SCHEMA = 'dbo'
order by COLUMN_NAME