Export (0) Print
Expand All

discounts

SQL Server 2000
Column_name Data type Nullable Default Check Key/index
discounttype varchar(40) no
stor_id char(4) yes FK stores(stor_id)
lowqty smallint yes
highqty smallint yes
discount float no

  

discounttype stor_id lowqty highqty discount
Initial Customer NULL NULL NULL 10.5
Volume Discount NULL 100 1000 6.7
Customer Discount 8042 NULL NULL 5.0

  

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft