• W7
    • Server Details
      • Server Properties
      • Server Parameters
      • Alerts
        • AlertErrorNumber
        • DropDatabaseWMI
        • JobAlert
        • KrystianAlert1
        • KrystianPerfAlert
        • test3
      • Backup Devices
        • backup3
          • Backupsets
            • 4
            • 6
        • backup4
          • Backupsets
            • 7
        • backup5
          • Backupsets
            • 7
        • BackupDevice2
        • KrystiannBackupDevice
      • Credentials
        • krystianCredential
        • krystianCredential2
      • Jobs
        • CMDJob
          • Job Steps
            • cmd1
            • cmd2
          • Job Schedules
            • a
        • KrystianJob
          • Job Steps
            • CreateTable
            • Insert
          • Job Schedules
            • WeeklyK
        • Start Optimize Catalog Population on AdventureWorks2008.AW2008FullTextCatalog
          • Job Steps
            • Full-Text Indexing
          • Job Schedules
            • Populate FT Catalog
            • FTS2
        • syspolicy_purge_history
          • Job Steps
            • Verify that automation is enabled.
            • Purge history.
            • Erase Phantom System Health Records.
          • Job Schedules
            • syspolicy_purge_history_schedule
      • Linked Servers
        • W7\SQLEXPRESS
      • Logins
        • ##MS_AgentSigningCertificate##
        • ##MS_PolicyEventProcessingLogin##
        • ##MS_PolicySigningCertificate##
        • ##MS_PolicyTsqlExecutionLogin##
        • ##MS_SQLAuthenticatorCertificate##
        • ##MS_SQLReplicationSigningCertificate##
        • ##MS_SQLResourceSigningCertificate##
        • BNFDbUser
        • cart
        • CertLogin
        • duser
        • InfrastructureMonitorUser
        • ireusableLogin
        • login_test
        • loginCredential
        • loginCredential2
        • msinvestment
        • NT AUTHORITY\LOCAL SERVICE
        • NT AUTHORITY\SYSTEM
        • NT SERVICE\MSSQLSERVER
        • NT SERVICE\SQLSERVERAGENT
        • piter
        • PROJECTENVISION\Accounting
        • PROJECTENVISION\ACL_Zarzad_Edit
        • PROJECTENVISION\Administrator
        • PROJECTENVISION\jfine
        • projectenvision\JohnBlack
        • PROJECTENVISION\krystian.zieja
        • PROJECTENVISION\svcSharePointW7
        • sa
        • sqldoc
        • tester
      • Operators
        • krystian
      • Server Roles
        • bulkadmin
        • dbcreator
        • diskadmin
        • processadmin
        • public
        • securityadmin
        • serveradmin
        • setupadmin
        • sysadmin
      • Server Triggers
        • connection_limit_trigger
        • connection_limit_trigger_2
        • ddl_trig_database
    • AdventureWorks2008
      • Database Details
      • Assemblies
        • KrystianUDT
        • Microsoft.SqlServer.Types
        • TestAssembly
      • Assymetric Keys
        • AsymetricTest
        • PacificSales09
        • PacificSales19
        • PacificSales29
      • Certificates
        • Shipping04
        • Shipping11
        • Shipping19
      • Contracts
        • //Adventure-Works.com/Expenses/ExpenseSubmission
        • DEFAULT
        • http://schemas.microsoft.com/SQL/Notifications/PostEventNotification
        • http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification
        • http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice
        • http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic
        • http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho
      • Datatypes
        • dbo.AccountNumber
        • dbo.completed
        • dbo.Flag
        • dbo.KrystianUDTType
        • dbo.mobiTable
        • dbo.MyTestType
        • dbo.Name
        • dbo.NameStyle
        • dbo.OrderNumber
        • dbo.Phone
        • dbo.SpecialCode
        • dbo.uddtssn
        • dbo.UDTSSN
      • DDL Triggers
        • ddlDatabaseTriggerLog
        • safety
      • Defaults
        • a
        • b
        • johnydefault
        • mydflt
        • phonedflt
          • Bound Columns
            • phone
        • socialdflt
          • Bound Columns
            • socialnumber
        • xavierdefault
        • xavierdefault2
        • xavierdefault3
      • Event Notifications
        • Notify_ALTER_T1
      • Full Text Catalogs
        • Catalogs List
          • AW2008FullTextCatalog
          • JohnCatalog
        • Document Types
      • Full Text Stoplists
        • krystianStoplist
        • kstoplist
        • myStoplist
      • Functions
        • dbo.aaa
        • dbo.bbb
        • dbo.fn_diagramobjects
        • dbo.ufnGetAccountingEndDate
        • dbo.ufnGetAccountingStartDate
        • dbo.ufnGetContactInformation
        • dbo.ufnGetDocumentStatusText
        • dbo.ufnGetProductDealerPrice
        • dbo.ufnGetProductListPrice
        • dbo.ufnGetProductStandardCost
        • dbo.ufnGetPurchaseOrderStatusText
        • dbo.ufnGetSalesOrderStatusText
        • dbo.ufnGetStock
        • dbo.ufnLeadingZeros
        • Sales.ufn_SalesByStore
      • Message Types
        • //Adventure-Works.com/Expenses/ExpenseApprovedOrDenied
        • //Adventure-Works.com/Expenses/ExpenseReimbursed
        • //Adventure-Works.com/Expenses/SubmitExpense
        • DEFAULT
        • http://schemas.microsoft.com/SQL/Notifications/EventNotification
        • http://schemas.microsoft.com/SQL/Notifications/QueryNotification
        • http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRemoteServiceBinding
        • http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRoute
        • http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRemoteServiceBinding
        • http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRoute
        • http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer
        • http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog
        • http://schemas.microsoft.com/SQL/ServiceBroker/Error
        • http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description
        • http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query
        • http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status
        • http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho/Echo
      • Partition Functions
        • dataPF1
        • myDateRangePF1
        • myRangePF1
        • myRangePF2
        • myRangePF3
        • myRangePF4
        • myRangePF5
      • Partition Schemes
        • datePS
        • myRangePS1
        • myRangePS2
        • myRangePS3
        • myRangePS4
        • myRangePS5
      • Procedures
        • aa
        • bb
        • sp_alterdiagram
        • sp_creatediagram
        • sp_dropdiagram
        • sp_helpdiagramdefinition
        • sp_helpdiagrams
        • sp_renamediagram
        • sp_t
        • sp_upgraddiagrams
        • usp_b
        • usp_delete_t99
        • usp_testddl
        • uspCurrencyCursor
        • uspGetBillOfMaterials
        • uspGetEmployeeManagers
        • uspGetManagerEmployees
        • uspGetWhereUsedProductID
        • uspLogError
        • uspPrintError
        • uspSearchCandidateResumes
        • uspUpdateEmployeeHireInfo
        • uspUpdateEmployeeLogin
        • uspUpdateEmployeePersonalInfo
        • uspGetList
      • Queues
        • dbo.EventNotificationErrorsQueue
        • dbo.ExpenseQueue
        • dbo.QueryNotificationErrorsQueue
        • dbo.ServiceBrokerQueue
      • Remote Service Bindings
        • APBinding
        • mobiBinding
      • Roles
        • db_accessadmin
        • db_backupoperator
        • db_datareader
        • db_datawriter
        • db_ddladmin
        • db_denydatareader
        • db_denydatawriter
        • db_owner
        • db_securityadmin
        • KrystianRole
        • public
        • weekly_receipts
      • Routes
        • AutoCreatedLocal
        • ExpenseRoute
      • Rules
        • list_rule
        • mobiRule
          • Bound Columns
            • sal
        • pattern_rule
        • range_rule
      • Schemas
        • db_accessadmin
        • db_backupoperator
        • db_datareader
        • db_datawriter
        • db_ddladmin
        • db_denydatareader
        • db_denydatawriter
        • db_owner
        • db_securityadmin
        • dbo
        • guest
        • HumanResources
        • INFORMATION_SCHEMA
        • Person
        • Production
        • Purchasing
        • Sales
        • sys
      • Services
        • //Adventure-Works.com/Expenses
        • http://schemas.microsoft.com/SQL/Notifications/EventNotificationService
        • http://schemas.microsoft.com/SQL/Notifications/QueryNotificationService
        • http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBroker
      • Symmetric Keys
        • ##MS_DatabaseMasterKey##
        • JanainaKey09
      • Synonyms
        • db_owner.tableSynonym
        • HumanResources.ProcedureSynonym
        • HumanResources.viewSynonym1
        • Person.functionSynonym
        • Person.otherDB
      • Tables
        • dbo.a0
          • Columns
            • my_uq
          • Indexes
            • UQ__a0__4933D9E90E240DFC
        • dbo.a1
          • Columns
            • id
            • c1
        • dbo.a1000
          • Columns
            • c1
        • dbo.a1001
          • Columns
            • c1
          • Indexes
            • PK__a1001__3213663B3C1FE2D6
        • dbo.AAA1
          • Columns
            • id
        • dbo.AWBuildVersion
          • Columns
            • SystemInformationID
            • Database Version
            • VersionDate
            • ModifiedDate
          • Indexes
            • PK_AWBuildVersion_SystemInformationID
        • dbo.DatabaseLog
          • Columns
            • DatabaseLogID
            • PostTime
            • DatabaseUser
            • Event
            • Schema
            • Object
            • TSQL
            • XmlEvent
          • Indexes
            • PK_DatabaseLog_DatabaseLogID
        • dbo.ErrorLog
          • Columns
            • ErrorLogID
            • ErrorTime
            • UserName
            • ErrorNumber
            • ErrorSeverity
            • ErrorState
            • ErrorProcedure
            • ErrorLine
            • ErrorMessage
          • Indexes
            • PK_ErrorLog_ErrorLogID
        • dbo.Globally_Unique_Data
          • Columns
            • guid
            • Employee_Name
          • Indexes
            • Guid_PK
        • dbo.mobiTableRule
          • Columns
            • id
            • sal
        • dbo.PartitionTable
          • Columns
            • col1
            • col2
        • dbo.Phones
          • Columns
            • cusid
            • phone
            • socialnumber
        • dbo.Records
          • Columns
            • Id
            • SerialNumber
            • Chart
          • Indexes
            • UQ__Records__048A000846136164
            • UQ__Records__3214EC0648EFCE0F
        • dbo.s
          • Columns
            • id
            • name
            • cnt
        • dbo.sysdiagrams
          • Columns
            • name
            • principal_id
            • diagram_id
            • version
            • definition
          • Indexes
            • PK__sysdiagr__C2B05B615CF6C6BC
            • UK_principal_name
        • dbo.t
          • Columns
            • id
            • name
            • cnt
        • dbo.t1
          • Columns
            • c1
            • c2
        • dbo.t10
          • Columns
            • c1
            • c2
            • c3
          • Indexes
            • t10_c2_idx
            • t10_c3_uq
        • dbo.t100
          • Columns
            • id
          • Indexes
            • PK__t100__3213E83F2F2FFC0C
        • dbo.t200
          • Columns
            • id
            • d
            • eventid
            • c
        • dbo.t3
          • Columns
            • id
        • dbo.t300
          • Columns
            • eventid
            • d
        • dbo.t5000
          • Columns
            • id
        • dbo.t99
          • Columns
            • id
        • dbo.tcolumnset
          • Columns
            • i
            • cs
        • dbo.tcomputed
          • Columns
            • id
            • qty
            • price
            • cost
        • dbo.test_table
          • Columns
            • column1
        • dbo.TestProduct
          • Columns
            • Name
            • ProductNumber
        • dbo.tid
          • Columns
            • c1
        • dbo.towner
          • Columns
            • id
        • dbo.trowguid2
          • Columns
            • c
        • dbo.tt
          • Columns
            • id
            • c
        • HumanResources.Department
          • Columns
            • DepartmentID
            • Name
            • GroupName
            • ModifiedDate
          • Indexes
            • PK_Department_DepartmentID
            • AK_Department_Name
        • HumanResources.Employee
          • Columns
            • BusinessEntityID
            • NationalIDNumber
            • LoginID
            • OrganizationNode
            • OrganizationLevel
            • JobTitle
            • BirthDate
            • MaritalStatus
            • Gender
            • HireDate
            • SalariedFlag
            • VacationHours
            • SickLeaveHours
            • CurrentFlag
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Employee_Person_BusinessEntityID
          • Indexes
            • PK_Employee_BusinessEntityID
            • IX_Employee_OrganizationNode
            • IX_Employee_OrganizationLevel_OrganizationNode
            • AK_Employee_LoginID
            • AK_Employee_NationalIDNumber
            • AK_Employee_rowguid
        • HumanResources.EmployeeDepartmentHistory
          • Columns
            • BusinessEntityID
            • DepartmentID
            • ShiftID
            • StartDate
            • EndDate
            • ModifiedDate
          • Foreign Keys
            • FK_EmployeeDepartmentHistory_Department_DepartmentID
            • FK_EmployeeDepartmentHistory_Employee_BusinessEntityID
            • FK_EmployeeDepartmentHistory_Shift_ShiftID
          • Indexes
            • PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID
            • IX_EmployeeDepartmentHistory_DepartmentID
            • IX_EmployeeDepartmentHistory_ShiftID
        • HumanResources.EmployeePayHistory
          • Columns
            • BusinessEntityID
            • RateChangeDate
            • Rate
            • PayFrequency
            • ModifiedDate
          • Foreign Keys
            • FK_EmployeePayHistory_Employee_BusinessEntityID
          • Indexes
            • PK_EmployeePayHistory_BusinessEntityID_RateChangeDate
        • HumanResources.JobCandidate
          • Columns
            • JobCandidateID
            • BusinessEntityID
            • Resume
            • ModifiedDate
          • Foreign Keys
            • FK_JobCandidate_Employee_BusinessEntityID
          • FullText Indexes
            • PK_JobCandidate_JobCandidateID
          • Indexes
            • PK_JobCandidate_JobCandidateID
            • IX_JobCandidate_BusinessEntityID
        • HumanResources.Shift
          • Columns
            • ShiftID
            • Name
            • StartTime
            • EndTime
            • ModifiedDate
          • Indexes
            • PK_Shift_ShiftID
            • AK_Shift_Name
            • AK_Shift_StartTime_EndTime
        • Person.Address
          • Columns
            • AddressID
            • AddressLine1
            • AddressLine2
            • City
            • StateProvinceID
            • PostalCode
            • SpatialLocation
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Address_StateProvince_StateProvinceID
          • Indexes
            • PK_Address_AddressID
            • AK_Address_rowguid
            • IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode
            • IX_Address_StateProvinceID
        • Person.AddressType
          • Columns
            • AddressTypeID
            • Name
            • rowguid
            • ModifiedDate
          • Indexes
            • PK_AddressType_AddressTypeID
            • AK_AddressType_rowguid
            • AK_AddressType_Name
        • Person.BusinessEntity
          • Columns
            • BusinessEntityID
            • rowguid
            • ModifiedDate
          • Indexes
            • PK_BusinessEntity_BusinessEntityID
            • AK_BusinessEntity_rowguid
        • Person.BusinessEntityAddress
          • Columns
            • BusinessEntityID
            • AddressID
            • AddressTypeID
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_BusinessEntityAddress_Address_AddressID
            • FK_BusinessEntityAddress_AddressType_AddressTypeID
            • FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID
          • Indexes
            • PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID
            • AK_BusinessEntityAddress_rowguid
            • IX_BusinessEntityAddress_AddressID
            • IX_BusinessEntityAddress_AddressTypeID
        • Person.BusinessEntityContact
          • Columns
            • BusinessEntityID
            • PersonID
            • ContactTypeID
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_BusinessEntityContact_Person_PersonID
            • FK_BusinessEntityContact_ContactType_ContactTypeID
            • FK_BusinessEntityContact_BusinessEntity_BusinessEntityID
          • Indexes
            • PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID
            • AK_BusinessEntityContact_rowguid
            • IX_BusinessEntityContact_PersonID
            • IX_BusinessEntityContact_ContactTypeID
        • Person.ContactType
          • Columns
            • ContactTypeID
            • Name
            • ModifiedDate
          • Indexes
            • PK_ContactType_ContactTypeID
            • AK_ContactType_Name
        • Person.CountryRegion
          • Columns
            • CountryRegionCode
            • Name
            • ModifiedDate
          • Indexes
            • PK_CountryRegion_CountryRegionCode
            • AK_CountryRegion_Name
        • Person.EmailAddress
          • Columns
            • BusinessEntityID
            • EmailAddressID
            • EmailAddress
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_EmailAddress_Person_BusinessEntityID
          • Indexes
            • PK_EmailAddress_BusinessEntityID_EmailAddressID
            • IX_EmailAddress_EmailAddress
        • Person.Password
          • Columns
            • BusinessEntityID
            • PasswordHash
            • PasswordSalt
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Password_Person_BusinessEntityID
          • Indexes
            • PK_Password_BusinessEntityID
        • Person.Person
          • Columns
            • BusinessEntityID
            • PersonType
            • NameStyle
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • EmailPromotion
            • AdditionalContactInfo
            • Demographics
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Person_BusinessEntity_BusinessEntityID
          • Indexes
            • PK_Person_BusinessEntityID
            • IX_Person_LastName_FirstName_MiddleName
            • AK_Person_rowguid
            • PXML_Person_AddContact
            • PXML_Person_Demographics
            • XMLPATH_Person_Demographics
            • XMLPROPERTY_Person_Demographics
            • XMLVALUE_Person_Demographics
        • Person.PersonPhone
          • Columns
            • BusinessEntityID
            • PhoneNumber
            • PhoneNumberTypeID
            • ModifiedDate
          • Foreign Keys
            • FK_PersonPhone_Person_BusinessEntityID
            • FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID
          • Indexes
            • PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID
            • IX_PersonPhone_PhoneNumber
        • Person.PhoneNumberType
          • Columns
            • PhoneNumberTypeID
            • Name
            • ModifiedDate
          • Indexes
            • PK_PhoneNumberType_PhoneNumberTypeID
        • Person.StateProvince
          • Columns
            • StateProvinceID
            • StateProvinceCode
            • CountryRegionCode
            • IsOnlyStateProvinceFlag
            • Name
            • TerritoryID
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_StateProvince_CountryRegion_CountryRegionCode
            • FK_StateProvince_SalesTerritory_TerritoryID
          • Indexes
            • PK_StateProvince_StateProvinceID
            • AK_StateProvince_Name
            • AK_StateProvince_StateProvinceCode_CountryRegionCode
            • AK_StateProvince_rowguid
        • Production.BillOfMaterials
          • Columns
            • BillOfMaterialsID
            • ProductAssemblyID
            • ComponentID
            • StartDate
            • EndDate
            • UnitMeasureCode
            • BOMLevel
            • PerAssemblyQty
            • ModifiedDate
          • Foreign Keys
            • FK_BillOfMaterials_Product_ProductAssemblyID
            • FK_BillOfMaterials_Product_ComponentID
            • FK_BillOfMaterials_UnitMeasure_UnitMeasureCode
          • Indexes
            • AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate
            • PK_BillOfMaterials_BillOfMaterialsID
            • IX_BillOfMaterials_UnitMeasureCode
        • Production.Culture
          • Columns
            • CultureID
            • Name
            • ModifiedDate
          • Indexes
            • PK_Culture_CultureID
            • AK_Culture_Name
        • Production.Document
          • Columns
            • DocumentNode
            • DocumentLevel
            • Title
            • Owner
            • FolderFlag
            • FileName
            • FileExtension
            • Revision
            • ChangeNumber
            • Status
            • DocumentSummary
            • Document
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Document_Employee_Owner
          • FullText Indexes
            • PK_Document_DocumentNode
          • Indexes
            • PK_Document_DocumentNode
            • UQ__Document__F73921F730F848ED
            • AK_Document_DocumentLevel_DocumentNode
            • AK_Document_rowguid
            • IX_Document_FileName_Revision
        • Production.Illustration
          • Columns
            • IllustrationID
            • Diagram
            • ModifiedDate
          • Indexes
            • PK_Illustration_IllustrationID
        • Production.Location
          • Columns
            • LocationID
            • Name
            • CostRate
            • Availability
            • ModifiedDate
          • Indexes
            • PK_Location_LocationID
            • AK_Location_Name
        • Production.Product
          • Columns
            • ProductID
            • Name
            • ProductNumber
            • MakeFlag
            • FinishedGoodsFlag
            • Color
            • SafetyStockLevel
            • ReorderPoint
            • StandardCost
            • ListPrice
            • Size
            • SizeUnitMeasureCode
            • WeightUnitMeasureCode
            • Weight
            • DaysToManufacture
            • ProductLine
            • Class
            • Style
            • ProductSubcategoryID
            • ProductModelID
            • SellStartDate
            • SellEndDate
            • DiscontinuedDate
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Product_UnitMeasure_SizeUnitMeasureCode
            • FK_Product_UnitMeasure_WeightUnitMeasureCode
            • FK_Product_ProductModel_ProductModelID
            • FK_Product_ProductSubcategory_ProductSubcategoryID
          • Indexes
            • PK_Product_ProductID
            • AK_Product_ProductNumber
            • AK_Product_Name
            • AK_Product_rowguid
        • Production.ProductCategory
          • Columns
            • ProductCategoryID
            • Name
            • rowguid
            • ModifiedDate
          • Indexes
            • PK_ProductCategory_ProductCategoryID
            • AK_ProductCategory_Name
            • AK_ProductCategory_rowguid
        • Production.ProductCostHistory
          • Columns
            • ProductID
            • StartDate
            • EndDate
            • StandardCost
            • ModifiedDate
          • Foreign Keys
            • FK_ProductCostHistory_Product_ProductID
          • Indexes
            • PK_ProductCostHistory_ProductID_StartDate
        • Production.ProductDescription
          • Columns
            • ProductDescriptionID
            • Description
            • rowguid
            • ModifiedDate
          • Indexes
            • PK_ProductDescription_ProductDescriptionID
            • AK_ProductDescription_rowguid
        • Production.ProductDocument
          • Columns
            • ProductID
            • DocumentNode
            • ModifiedDate
          • Foreign Keys
            • FK_ProductDocument_Product_ProductID
            • FK_ProductDocument_Document_DocumentNode
          • Indexes
            • PK_ProductDocument_ProductID_DocumentNode
        • Production.ProductInventory
          • Columns
            • ProductID
            • LocationID
            • Shelf
            • Bin
            • Quantity
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_ProductInventory_Location_LocationID
            • FK_ProductInventory_Product_ProductID
          • Indexes
            • PK_ProductInventory_ProductID_LocationID
        • Production.ProductListPriceHistory
          • Columns
            • ProductID
            • StartDate
            • EndDate
            • ListPrice
            • ModifiedDate
          • Foreign Keys
            • FK_ProductListPriceHistory_Product_ProductID
          • Indexes
            • PK_ProductListPriceHistory_ProductID_StartDate
        • Production.ProductModel
          • Columns
            • ProductModelID
            • Name
            • CatalogDescription
            • Instructions
            • rowguid
            • ModifiedDate
          • Indexes
            • PK_ProductModel_ProductModelID
            • AK_ProductModel_Name
            • AK_ProductModel_rowguid
            • PXML_ProductModel_CatalogDescription
            • PXML_ProductModel_Instructions
        • Production.ProductModelIllustration
          • Columns
            • ProductModelID
            • IllustrationID
            • ModifiedDate
          • Foreign Keys
            • FK_ProductModelIllustration_ProductModel_ProductModelID
            • FK_ProductModelIllustration_Illustration_IllustrationID
          • Indexes
            • PK_ProductModelIllustration_ProductModelID_IllustrationID
        • Production.ProductModelProductDescriptionCulture
          • Columns
            • ProductModelID
            • ProductDescriptionID
            • CultureID
            • ModifiedDate
          • Foreign Keys
            • FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID
            • FK_ProductModelProductDescriptionCulture_Culture_CultureID
            • FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID
          • Indexes
            • PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
        • Production.ProductPhoto
          • Columns
            • ProductPhotoID
            • ThumbNailPhoto
            • ThumbnailPhotoFileName
            • LargePhoto
            • LargePhotoFileName
            • ModifiedDate
          • Indexes
            • PK_ProductPhoto_ProductPhotoID
        • Production.ProductProductPhoto
          • Columns
            • ProductID
            • ProductPhotoID
            • Primary
            • ModifiedDate
          • Foreign Keys
            • FK_ProductProductPhoto_Product_ProductID
            • FK_ProductProductPhoto_ProductPhoto_ProductPhotoID
          • Indexes
            • PK_ProductProductPhoto_ProductID_ProductPhotoID
        • Production.ProductReview
          • Columns
            • ProductReviewID
            • ProductID
            • ReviewerName
            • ReviewDate
            • EmailAddress
            • Rating
            • Comments
            • ModifiedDate
          • Foreign Keys
            • FK_ProductReview_Product_ProductID
          • FullText Indexes
            • PK_ProductReview_ProductReviewID
          • Indexes
            • PK_ProductReview_ProductReviewID
            • IX_ProductReview_ProductID_Name
        • Production.ProductSubcategory
          • Columns
            • ProductSubcategoryID
            • ProductCategoryID
            • Name
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_ProductSubcategory_ProductCategory_ProductCategoryID
          • Indexes
            • PK_ProductSubcategory_ProductSubcategoryID
            • AK_ProductSubcategory_Name
            • AK_ProductSubcategory_rowguid
        • Production.ScrapReason
          • Columns
            • ScrapReasonID
            • Name
            • ModifiedDate
          • Indexes
            • PK_ScrapReason_ScrapReasonID
            • AK_ScrapReason_Name
        • Production.TransactionHistory
          • Columns
            • TransactionID
            • ProductID
            • ReferenceOrderID
            • ReferenceOrderLineID
            • TransactionDate
            • TransactionType
            • Quantity
            • ActualCost
            • ModifiedDate
          • Foreign Keys
            • FK_TransactionHistory_Product_ProductID
          • Indexes
            • PK_TransactionHistory_TransactionID
            • IX_TransactionHistory_ProductID
            • IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID
            • IX_TransactionHistory_ReferenceOrderID
        • Production.TransactionHistoryArchive
          • Columns
            • TransactionID
            • ProductID
            • ReferenceOrderID
            • ReferenceOrderLineID
            • TransactionDate
            • TransactionType
            • Quantity
            • ActualCost
            • ModifiedDate
          • Indexes
            • PK_TransactionHistoryArchive_TransactionID
            • IX_TransactionHistoryArchive_ProductID
            • IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID
        • Production.UnitMeasure
          • Columns
            • UnitMeasureCode
            • Name
            • ModifiedDate
          • Indexes
            • PK_UnitMeasure_UnitMeasureCode
            • AK_UnitMeasure_Name
        • Production.WorkOrder
          • Columns
            • WorkOrderID
            • ProductID
            • OrderQty
            • StockedQty
            • ScrappedQty
            • StartDate
            • EndDate
            • DueDate
            • ScrapReasonID
            • ModifiedDate
          • Foreign Keys
            • FK_WorkOrder_Product_ProductID
            • FK_WorkOrder_ScrapReason_ScrapReasonID
          • Indexes
            • PK_WorkOrder_WorkOrderID
            • IX_WorkOrder_ScrapReasonID
            • IX_WorkOrder_ProductID
        • Production.WorkOrderRouting
          • Columns
            • WorkOrderID
            • ProductID
            • OperationSequence
            • LocationID
            • ScheduledStartDate
            • ScheduledEndDate
            • ActualStartDate
            • ActualEndDate
            • ActualResourceHrs
            • PlannedCost
            • ActualCost
            • ModifiedDate
          • Foreign Keys
            • FK_WorkOrderRouting_Location_LocationID
            • FK_WorkOrderRouting_WorkOrder_WorkOrderID
          • Indexes
            • PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence
            • IX_WorkOrderRouting_ProductID
        • Purchasing.ProductVendor
          • Columns
            • ProductID
            • BusinessEntityID
            • AverageLeadTime
            • StandardPrice
            • LastReceiptCost
            • LastReceiptDate
            • MinOrderQty
            • MaxOrderQty
            • OnOrderQty
            • UnitMeasureCode
            • ModifiedDate
          • Foreign Keys
            • FK_ProductVendor_Product_ProductID
            • FK_ProductVendor_UnitMeasure_UnitMeasureCode
            • FK_ProductVendor_Vendor_BusinessEntityID
          • Indexes
            • PK_ProductVendor_ProductID_BusinessEntityID
            • IX_ProductVendor_UnitMeasureCode
            • IX_ProductVendor_BusinessEntityID
        • Purchasing.PurchaseOrderDetail
          • Columns
            • PurchaseOrderID
            • PurchaseOrderDetailID
            • DueDate
            • OrderQty
            • ProductID
            • UnitPrice
            • LineTotal
            • ReceivedQty
            • RejectedQty
            • StockedQty
            • ModifiedDate
          • Foreign Keys
            • FK_PurchaseOrderDetail_Product_ProductID
            • FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID
          • Indexes
            • PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID
            • IX_PurchaseOrderDetail_ProductID
        • Purchasing.PurchaseOrderHeader
          • Columns
            • PurchaseOrderID
            • RevisionNumber
            • Status
            • EmployeeID
            • VendorID
            • ShipMethodID
            • OrderDate
            • ShipDate
            • SubTotal
            • TaxAmt
            • Freight
            • TotalDue
            • ModifiedDate
          • Foreign Keys
            • FK_PurchaseOrderHeader_Employee_EmployeeID
            • FK_PurchaseOrderHeader_Vendor_VendorID
            • FK_PurchaseOrderHeader_ShipMethod_ShipMethodID
          • Indexes
            • PK_PurchaseOrderHeader_PurchaseOrderID
            • IX_PurchaseOrderHeader_VendorID
            • IX_PurchaseOrderHeader_EmployeeID
        • Purchasing.ShipMethod
          • Columns
            • ShipMethodID
            • Name
            • ShipBase
            • ShipRate
            • rowguid
            • ModifiedDate
          • Indexes
            • PK_ShipMethod_ShipMethodID
            • AK_ShipMethod_Name
            • AK_ShipMethod_rowguid
        • Purchasing.Vendor
          • Columns
            • BusinessEntityID
            • AccountNumber
            • Name
            • CreditRating
            • PreferredVendorStatus
            • ActiveFlag
            • PurchasingWebServiceURL
            • ModifiedDate
          • Foreign Keys
            • FK_Vendor_BusinessEntity_BusinessEntityID
          • Indexes
            • PK_Vendor_BusinessEntityID
            • AK_Vendor_AccountNumber
        • Sales.CountryRegionCurrency
          • Columns
            • CountryRegionCode
            • CurrencyCode
            • ModifiedDate
          • Foreign Keys
            • FK_CountryRegionCurrency_CountryRegion_CountryRegionCode
            • FK_CountryRegionCurrency_Currency_CurrencyCode
          • Indexes
            • PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode
            • IX_CountryRegionCurrency_CurrencyCode
        • Sales.CreditCard
          • Columns
            • CreditCardID
            • CardType
            • CardNumber
            • ExpMonth
            • ExpYear
            • ModifiedDate
          • Indexes
            • PK_CreditCard_CreditCardID
            • AK_CreditCard_CardNumber
        • Sales.Currency
          • Columns
            • CurrencyCode
            • Name
            • ModifiedDate
          • Indexes
            • PK_Currency_CurrencyCode
            • AK_Currency_Name
        • Sales.CurrencyRate
          • Columns
            • CurrencyRateID
            • CurrencyRateDate
            • FromCurrencyCode
            • ToCurrencyCode
            • AverageRate
            • EndOfDayRate
            • ModifiedDate
          • Foreign Keys
            • FK_CurrencyRate_Currency_FromCurrencyCode
            • FK_CurrencyRate_Currency_ToCurrencyCode
          • Indexes
            • PK_CurrencyRate_CurrencyRateID
            • AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode
        • Sales.Customer
          • Columns
            • CustomerID
            • PersonID
            • StoreID
            • TerritoryID
            • AccountNumber
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Customer_Person_PersonID
            • FK_Customer_Store_StoreID
            • FK_Customer_SalesTerritory_TerritoryID
          • Indexes
            • PK_Customer_CustomerID
            • AK_Customer_rowguid
            • AK_Customer_AccountNumber
            • IX_Customer_TerritoryID
        • Sales.mobiFT
          • Columns
            • id
            • zjebka
          • FullText Indexes
            • PK__mobiFT__3213E83F642DD430
          • Indexes
            • PK__mobiFT__3213E83F642DD430
        • Sales.PersonCreditCard
          • Columns
            • BusinessEntityID
            • CreditCardID
            • ModifiedDate
          • Foreign Keys
            • FK_PersonCreditCard_Person_BusinessEntityID
            • FK_PersonCreditCard_CreditCard_CreditCardID
          • Indexes
            • PK_PersonCreditCard_BusinessEntityID_CreditCardID
        • Sales.SalesOrderDetail
          • Columns
            • SalesOrderID
            • SalesOrderDetailID
            • CarrierTrackingNumber
            • OrderQty
            • ProductID
            • SpecialOfferID
            • UnitPrice
            • UnitPriceDiscount
            • LineTotal
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID
            • FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID
          • Indexes
            • PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID
            • AK_SalesOrderDetail_rowguid
            • IX_SalesOrderDetail_ProductID
        • Sales.SalesOrderHeader
          • Columns
            • SalesOrderID
            • RevisionNumber
            • OrderDate
            • DueDate
            • ShipDate
            • Status
            • OnlineOrderFlag
            • SalesOrderNumber
            • PurchaseOrderNumber
            • AccountNumber
            • CustomerID
            • SalesPersonID
            • TerritoryID
            • BillToAddressID
            • ShipToAddressID
            • ShipMethodID
            • CreditCardID
            • CreditCardApprovalCode
            • CurrencyRateID
            • SubTotal
            • TaxAmt
            • Freight
            • TotalDue
            • Comment
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SalesOrderHeader_Address_BillToAddressID
            • FK_SalesOrderHeader_Address_ShipToAddressID
            • FK_SalesOrderHeader_CreditCard_CreditCardID
            • FK_SalesOrderHeader_CurrencyRate_CurrencyRateID
            • FK_SalesOrderHeader_Customer_CustomerID
            • FK_SalesOrderHeader_SalesPerson_SalesPersonID
            • FK_SalesOrderHeader_ShipMethod_ShipMethodID
            • FK_SalesOrderHeader_SalesTerritory_TerritoryID
          • Indexes
            • PK_SalesOrderHeader_SalesOrderID
            • AK_SalesOrderHeader_rowguid
            • AK_SalesOrderHeader_SalesOrderNumber
            • IX_SalesOrderHeader_CustomerID
            • IX_SalesOrderHeader_SalesPersonID
        • Sales.SalesOrderHeaderSalesReason
          • Columns
            • SalesOrderID
            • SalesReasonID
            • ModifiedDate
          • Foreign Keys
            • FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID
            • FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID
          • Indexes
            • PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID
        • Sales.SalesPerson
          • Columns
            • BusinessEntityID
            • TerritoryID
            • SalesQuota
            • Bonus
            • CommissionPct
            • SalesYTD
            • SalesLastYear
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SalesPerson_Employee_BusinessEntityID
            • FK_SalesPerson_SalesTerritory_TerritoryID
          • Indexes
            • PK_SalesPerson_BusinessEntityID
            • AK_SalesPerson_rowguid
        • Sales.SalesPersonQuotaHistory
          • Columns
            • BusinessEntityID
            • QuotaDate
            • SalesQuota
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID
          • Indexes
            • PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate
            • AK_SalesPersonQuotaHistory_rowguid
        • Sales.SalesReason
          • Columns
            • SalesReasonID
            • Name
            • ReasonType
            • ModifiedDate
          • Indexes
            • PK_SalesReason_SalesReasonID
        • Sales.SalesTaxRate
          • Columns
            • SalesTaxRateID
            • StateProvinceID
            • TaxType
            • TaxRate
            • Name
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SalesTaxRate_StateProvince_StateProvinceID
          • Indexes
            • PK_SalesTaxRate_SalesTaxRateID
            • AK_SalesTaxRate_StateProvinceID_TaxType
            • AK_SalesTaxRate_rowguid
        • Sales.SalesTerritory
          • Columns
            • TerritoryID
            • Name
            • CountryRegionCode
            • Group
            • SalesYTD
            • SalesLastYear
            • CostYTD
            • CostLastYear
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SalesTerritory_CountryRegion_CountryRegionCode
          • Indexes
            • PK_SalesTerritory_TerritoryID
            • AK_SalesTerritory_Name
            • AK_SalesTerritory_rowguid
        • Sales.SalesTerritoryHistory
          • Columns
            • BusinessEntityID
            • TerritoryID
            • StartDate
            • EndDate
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID
            • FK_SalesTerritoryHistory_SalesTerritory_TerritoryID
          • Indexes
            • PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID
            • AK_SalesTerritoryHistory_rowguid
        • Sales.ShoppingCartItem
          • Columns
            • ShoppingCartItemID
            • ShoppingCartID
            • Quantity
            • ProductID
            • DateCreated
            • ModifiedDate
          • Foreign Keys
            • FK_ShoppingCartItem_Product_ProductID
          • Indexes
            • PK_ShoppingCartItem_ShoppingCartItemID
            • IX_ShoppingCartItem_ShoppingCartID_ProductID
        • Sales.SpecialOffer
          • Columns
            • SpecialOfferID
            • Description
            • DiscountPct
            • Type
            • Category
            • StartDate
            • EndDate
            • MinQty
            • MaxQty
            • rowguid
            • ModifiedDate
          • Indexes
            • PK_SpecialOffer_SpecialOfferID
            • AK_SpecialOffer_rowguid
        • Sales.SpecialOfferProduct
          • Columns
            • SpecialOfferID
            • ProductID
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_SpecialOfferProduct_Product_ProductID
            • FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID
          • Indexes
            • PK_SpecialOfferProduct_SpecialOfferID_ProductID
            • AK_SpecialOfferProduct_rowguid
            • IX_SpecialOfferProduct_ProductID
        • Sales.Store
          • Columns
            • BusinessEntityID
            • Name
            • SalesPersonID
            • Demographics
            • rowguid
            • ModifiedDate
          • Foreign Keys
            • FK_Store_BusinessEntity_BusinessEntityID
            • FK_Store_SalesPerson_SalesPersonID
          • Indexes
            • PK_Store_BusinessEntityID
            • AK_Store_rowguid
            • IX_Store_SalesPersonID
            • PXML_Store_Demographics
      • Triggers
        • iup_t200_trg
        • trg_ins_t1
        • uMobiEmployeeTrg
        • dEmployee
        • iuPerson
        • iWorkOrder
        • uWorkOrder
        • dVendor
        • iPurchaseOrderDetail
        • uPurchaseOrderDetail
        • uPurchaseOrderHeader
        • iduSalesOrderDetail
        • uSalesOrderHeader
      • Users
        • cart
        • dbo
        • duser
        • guest
        • INFORMATION_SCHEMA
        • JohnBlack
        • sys
      • Views
        • KrystianProductView
          • Columns
            • Name
            • ProductNumber
        • vMobiEmployee
          • Indexes
            • PK_vMobiEmployee_NationalIDNumber
            • AK_vMobiEmployee
          • Columns
            • NationalIDNumber
            • JobTitle
            • BirthDate
        • vw_Globally_Unique_Data
          • Columns
            • guid
            • Employee_Name
        • vw_Records
          • Columns
            • Id
            • SerialNumber
            • Chart
        • vw_tcolumnset
          • Columns
            • cs
        • vw_tcolumnset2
          • Columns
            • cs
        • vw_tcomputed
          • Columns
            • id
            • qty
            • price
            • cost
        • vw_tid
          • Columns
            • c1
        • vw_trowguid2
          • Columns
            • c
        • vEmployee
          • Columns
            • BusinessEntityID
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • JobTitle
            • PhoneNumber
            • PhoneNumberType
            • EmailAddress
            • EmailPromotion
            • AddressLine1
            • AddressLine2
            • City
            • StateProvinceName
            • PostalCode
            • CountryRegionName
            • AdditionalContactInfo
        • vEmployeeDepartment
          • Columns
            • BusinessEntityID
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • JobTitle
            • Department
            • GroupName
            • StartDate
        • vEmployeeDepartmentHistory
          • Columns
            • BusinessEntityID
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • Shift
            • Department
            • GroupName
            • StartDate
            • EndDate
        • vJobCandidate
          • Columns
            • JobCandidateID
            • BusinessEntityID
            • Name.Prefix
            • Name.First
            • Name.Middle
            • Name.Last
            • Name.Suffix
            • Skills
            • Addr.Type
            • Addr.Loc.CountryRegion
            • Addr.Loc.State
            • Addr.Loc.City
            • Addr.PostalCode
            • EMail
            • WebSite
            • ModifiedDate
        • vJobCandidateEducation
          • Columns
            • JobCandidateID
            • Edu.Level
            • Edu.StartDate
            • Edu.EndDate
            • Edu.Degree
            • Edu.Major
            • Edu.Minor
            • Edu.GPA
            • Edu.GPAScale
            • Edu.School
            • Edu.Loc.CountryRegion
            • Edu.Loc.State
            • Edu.Loc.City
        • vJobCandidateEmployment
          • Columns
            • JobCandidateID
            • Emp.StartDate
            • Emp.EndDate
            • Emp.OrgName
            • Emp.JobTitle
            • Emp.Responsibility
            • Emp.FunctionCategory
            • Emp.IndustryCategory
            • Emp.Loc.CountryRegion
            • Emp.Loc.State
            • Emp.Loc.City
        • vAdditionalContactInfo
          • Columns
            • BusinessEntityID
            • FirstName
            • MiddleName
            • LastName
            • TelephoneNumber
            • TelephoneSpecialInstructions
            • Street
            • City
            • StateProvince
            • PostalCode
            • CountryRegion
            • HomeAddressSpecialInstructions
            • EMailAddress
            • EMailSpecialInstructions
            • EMailTelephoneNumber
            • rowguid
            • ModifiedDate
        • vStateProvinceCountryRegion
          • Indexes
            • IX_vStateProvinceCountryRegion
          • Columns
            • StateProvinceID
            • StateProvinceCode
            • IsOnlyStateProvinceFlag
            • StateProvinceName
            • TerritoryID
            • CountryRegionCode
            • CountryRegionName
        • vProductAndDescription
          • Indexes
            • IX_vProductAndDescription
          • Columns
            • ProductID
            • Name
            • ProductModel
            • CultureID
            • Description
        • vProductModelCatalogDescription
          • Columns
            • ProductModelID
            • Name
            • Summary
            • Manufacturer
            • Copyright
            • ProductURL
            • WarrantyPeriod
            • WarrantyDescription
            • NoOfYears
            • MaintenanceDescription
            • Wheel
            • Saddle
            • Pedal
            • BikeFrame
            • Crankset
            • PictureAngle
            • PictureSize
            • ProductPhotoID
            • Material
            • Color
            • ProductLine
            • Style
            • RiderExperience
            • rowguid
            • ModifiedDate
        • vProductModelInstructions
          • Columns
            • ProductModelID
            • Name
            • Instructions
            • LocationID
            • SetupHours
            • MachineHours
            • LaborHours
            • LotSize
            • Step
            • rowguid
            • ModifiedDate
        • vVendorWithAddresses
          • Columns
            • BusinessEntityID
            • Name
            • AddressType
            • AddressLine1
            • AddressLine2
            • City
            • StateProvinceName
            • PostalCode
            • CountryRegionName
        • vVendorWithContacts
          • Columns
            • BusinessEntityID
            • Name
            • ContactType
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • PhoneNumber
            • PhoneNumberType
            • EmailAddress
            • EmailPromotion
        • mobiFTView
          • Columns
            • id
            • zjebka_rulez
        • vIndividualCustomer
          • Columns
            • BusinessEntityID
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • PhoneNumber
            • PhoneNumberType
            • EmailAddress
            • EmailPromotion
            • AddressType
            • AddressLine1
            • AddressLine2
            • City
            • StateProvinceName
            • PostalCode
            • CountryRegionName
            • Demographics
        • vPersonDemographics
          • Columns
            • BusinessEntityID
            • TotalPurchaseYTD
            • DateFirstPurchase
            • BirthDate
            • MaritalStatus
            • YearlyIncome
            • Gender
            • TotalChildren
            • NumberChildrenAtHome
            • Education
            • Occupation
            • HomeOwnerFlag
            • NumberCarsOwned
        • vSalesPerson
          • Columns
            • BusinessEntityID
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • JobTitle
            • PhoneNumber
            • PhoneNumberType
            • EmailAddress
            • EmailPromotion
            • AddressLine1
            • AddressLine2
            • City
            • StateProvinceName
            • PostalCode
            • CountryRegionName
            • TerritoryName
            • TerritoryGroup
            • SalesQuota
            • SalesYTD
            • SalesLastYear
        • vSalesPersonSalesByFiscalYears
          • Columns
            • SalesPersonID
            • FullName
            • JobTitle
            • SalesTerritory
            • 2002
            • 2003
            • 2004
        • vStoreWithAddresses
          • Columns
            • BusinessEntityID
            • Name
            • AddressType
            • AddressLine1
            • AddressLine2
            • City
            • StateProvinceName
            • PostalCode
            • CountryRegionName
        • vStoreWithContacts
          • Columns
            • BusinessEntityID
            • Name
            • ContactType
            • Title
            • FirstName
            • MiddleName
            • LastName
            • Suffix
            • PhoneNumber
            • PhoneNumberType
            • EmailAddress
            • EmailPromotion
        • vStoreWithDemographics
          • Columns
            • BusinessEntityID
            • Name
            • AnnualSales
            • AnnualRevenue
            • BankName
            • BusinessType
            • YearOpened
            • Specialty
            • SquareFeet
            • Brands
            • Internet
            • NumberEmployees
      • Xml Collections
        • dbo.KrystianSchemaProducts
        • HumanResources.HRResumeSchemaCollection
        • Person.AdditionalContactInfoSchemaCollection
        • Person.IndividualSurveySchemaCollection
        • Production.ManuInstructionsSchemaCollection
        • Production.ProductDescriptionSchemaCollection
        • Sales.StoreSurveySchemaCollection