Datatype: [AdventureWorks2016CTP3].[dbo].[Flag]

CollapseAll image

Collapse image Properties


 Name   Value 
 Name   [Flag] 
 Schema   [dbo] 
 Owner   [dbo] 
 Storage type   bit 
 Maximum  length (chars or Bytes)   1 
 Precision   1 
 Scale   0 
 Allow nulls   
 Rule     
 Default     
 ID   258 
 Is assembly type    
 Is table type    
 Is memory optimized    

Collapse image Columns defined on


Name  Parent  Description
CurrentFlag [HumanResources].[Employee]  
SalariedFlag [HumanResources].[Employee]  
Test column 3 [HumanResources].[Employee]  
@CurrentFlag [HumanResources].[uspUpdateEmployeeHireInfo]  
@CurrentFlag [HumanResources].[uspUpdateEmployeeLogin]  
IsOnlyStateProvinceFlag [Person].[StateProvince]  
IsOnlyStateProvinceFlag [Person].[vStateProvinceCountryRegion]  
FinishedGoodsFlag [Production].[Product]  
MakeFlag [Production].[Product]  
Primary [Production].[ProductProductPhoto]  
ActiveFlag [Purchasing].[Vendor]  
PreferredVendorStatus [Purchasing].[Vendor]  
OnlineOrderFlag [Sales].[SalesOrder_json]  
OnlineOrderFlag [Sales].[SalesOrderHeader]  
Total: 14 column(s)

Collapse image Objects that depend on [dbo].[Flag]


Object name Object type Dep level
[HumanResources].[uspUpdateEmployeeHireInfo] Procedure 1
[HumanResources].[uspUpdateEmployeeLogin] Procedure 1
[HumanResources].[Employee] Table 1
[Production].[Product] Table 1
[Production].[ProductProductPhoto] Table 1
[Sales].[SalesOrder_json] Table 1
[Sales].[SalesOrderHeader] Table 1
[Person].[StateProvince] Table 1
[Purchasing].[Vendor] Table 1
Total 9 object(s)

Collapse image SQL


CREATE TYPE [dbo].[Flag]
    FROM [bit]
    NOT NULL
GO

Collapse image See also


List of datatypes