Usage of ModifiedDate

CollapseAll image

Collapse image ModifiedDate


Object name  Description  Data type  Length  Parent object type Type
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Address]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[AddressType]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[dbo].[AWBuildVersion]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[BillOfMaterials]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[BusinessEntityAddress]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[BusinessEntity]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[BusinessEntityContact]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[ContactType]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[CountryRegion]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[CountryRegionCurrency]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[CreditCard]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[Culture]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[Currency]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[CurrencyRate]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[Customer]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[Department]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[Document]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[EmailAddress]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[Employee]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[EmployeeDepartmentHistory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[EmployeePayHistory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[Illustration]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[JobCandidate]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[Location]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Password]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Person_json]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[Person]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[PersonCreditCard]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[PersonPhone]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[PhoneNumberType]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[Product_inmem]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[Product_ondisk]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[Product]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductCategory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductCostHistory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductDescription]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductDocument]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductInventory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductListPriceHistory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductModel]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductModelIllustration]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductModelProductDescriptionCulture]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductPhoto]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductProductPhoto]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductReview]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ProductSubcategory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[ProductVendor]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[PurchaseOrderDetail]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[PurchaseOrderHeader]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrder_json]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrderDetail_inmem]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrderDetail_ondisk]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrderDetail]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrderHeader_inmem]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrderHeader_ondisk]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrderHeader]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesOrderHeaderSalesReason]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesPerson]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesPersonQuotaHistory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesReason]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesTaxRate]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesTerritory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SalesTerritoryHistory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[ScrapReason]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[Shift]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[ShipMethod]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[ShoppingCartItem]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SpecialOffer_inmem]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SpecialOffer_ondisk]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SpecialOffer]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SpecialOfferProduct_inmem]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SpecialOfferProduct_ondisk]   datetime2 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[SpecialOfferProduct]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[StateProvince]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Sales].[Store]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[TransactionHistory]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[TransactionHistoryArchive]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[UnitMeasure]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Person].[vAdditionalContactInfo]   datetime 8 View Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Purchasing].[Vendor]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[HumanResources].[vJobCandidate]   datetime 8 View Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[vProductModelCatalogDescription]   datetime 8 View Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[vProductModelInstructions]   datetime 8 View Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[WorkOrder]   datetime 8 Table Column
[ALEN-PC\SQLSERVER2016].[AdventureWorks2016CTP3].[Production].[WorkOrderRouting]   datetime 8 Table Column
Total: 85 objects

Collapse image See also


Server index