Generated using SQL Data Dictionary demo version.


Table Sales.Customers_Archive (51 rows)


  Column Data Type Identity Nullable Default
CustomerID int
CustomerName nvarchar(100)
BillToCustomerID int
CustomerCategoryID int
BuyingGroupID int X
PrimaryContactPersonID int
AlternateContactPersonID int X
DeliveryMethodID int
DeliveryCityID int
PostalCityID int
CreditLimit decimal(18,2) X
AccountOpenedDate date
StandardDiscountPercentage decimal(18,3)
IsStatementSent bit
IsOnCreditHold bit
PaymentDays int
PhoneNumber nvarchar(20)
FaxNumber nvarchar(20)
DeliveryRun nvarchar(5) X
RunPosition nvarchar(5) X
WebsiteURL nvarchar(256)
DeliveryAddressLine1 nvarchar(60)
DeliveryAddressLine2 nvarchar(60) X
DeliveryPostalCode nvarchar(10)
DeliveryLocation geography X
PostalAddressLine1 nvarchar(60)
PostalAddressLine2 nvarchar(60) X
PostalPostalCode nvarchar(10)
LastEditedBy int
ValidFrom datetime2
ValidTo datetime2

Indexes:


Used by: