Datatype: [AdventureWorks2016CTP3].[dbo].[Flag]
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 |
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] |
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 |
SQL
CREATE TYPE [dbo].[Flag] FROM [bit] NOT NULL GO |
See also