dbo.Flag User Defined Data Type Properties Allow Identity Allow Nulls Base Typebit Default Variable Length Length1 Max Size1 Numeric Precision1 Numeric scale0 Rule Collation Columns in which this object is used TableColumn NameDescription EmployeeSalariedFlagJob classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining. EmployeeCurrentFlag0 = Inactive, 1 = Active StateProvinceIsOnlyStateProvinceFlag0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. ProductMakeFlag0 = Product is purchased, 1 = Product is manufactured in-house. ProductFinishedGoodsFlag0 = Product is not a salable item. 1 = Product is salable. ProductProductPhotoPrimary0 = Photo is not the principal image. 1 = Photo is the principal image. VendorPreferredVendorStatus0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product. VendorActiveFlag0 = Vendor no longer used. 1 = Vendor is actively used. SalesOrderHeaderOnlineOrderFlag0 = Order placed by sales person. 1 = Order placed online by customer. SQLCREATE TYPE [dbo].[Flag] FROM [bit] NOT NULL See AlsoRelated Objectsdbo Schema AdventureWorks Database
