Table: [AdventureWorks2016CTP3].[Sales].[CustomerPII]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [Sales]
 Owner  [dbo]
 Table is replicated   
 Creation date  23.10.2015
 ID  1748201278
 Located on  PRIMARY
 Data size KB  7992 KB
 Index size KB  8 KB
 Rows  19118
 ChangeTrackingEnabled   
 FileStreamFileGroup   
 FileStreamPartitionScheme   
 LockEscalation  TABLE
 TrackColumnsUpdatedEnabled   
 Table is filetable   
 Filetable directory   
 Filetable collate   
 Filetable primary key   
 Filetable streamid unique   
 Filetable fullpath unique   
 Filetable is enabled   
 Is memory optimized   
 Durability  SCHEMA_AND_DATA

Collapse image Creation options


Name  Value 
QUOTED_IDENTIFIER ON
ANSI_NULLS ON
ANSI_PADDING ON

Collapse image Columns


  Name  Description  Data type  Max length  Nullable  Default IsGUID  SPARSE Computed value
  CustomerID     int 4        
  FirstName     [dbo].[Name] 50        
  LastName     [dbo].[Name] 50        
  SSN     nvarchar 11      
  CreditCardNumber     nvarchar 25      
  EmailAddress     nvarchar 50      
  PhoneNumber     nvarchar 25      
  TerritoryID     int 4      
Total: 8 column(s)

Collapse image Objects that [Sales].[CustomerPII] depends on


Object name Object type Dep level
[dbo].[SalesManagers] Role 1
[dbo].[SalesPersons] Role 1
[Sales] Schema 1
[dbo].[Name] Datatype 1
Total 4 object(s)

Collapse image Permissions


User/role  Alter Control Select Insert Update Delete DRI Take
ownership 
View
definition 
Columns 
[dbo].[SalesManagers]Columns
[dbo].[SalesPersons]Columns

Collapse image Table options


Name  Value 
Pintable OFF
Table lock on bulk load OFF
Insert row lock OFF
Text in row 0
Large value types out of row OFF

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [Sales].[CustomerPII] (
        [CustomerID]           [int] NOT NULL,
        [FirstName]            [dbo].[Name] NOT NULL,
        [LastName]             [dbo].[Name] NOT NULL,
        [SSN]                  [nvarchar](11) COLLATE Latin1_General_BIN2 NULL,
        [CreditCardNumber]     [nvarchar](25) COLLATE Latin1_General_BIN2 NULL,
        [EmailAddress]         [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS MASKED WITH (FUNCTION = 'email()') NULL,
        [PhoneNumber]          [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS MASKED WITH (FUNCTION = 'default()') NULL,
        [TerritoryID]          [int] NULL
) ON [PRIMARY]
GO
GRANT DELETE
    ON [Sales].[CustomerPII]
    TO [SalesManagers]
GO
GRANT DELETE
    ON [Sales].[CustomerPII]
    TO [SalesPersons]
GO
GRANT INSERT
    ON [Sales].[CustomerPII]
    TO [SalesManagers]
GO
GRANT INSERT
    ON [Sales].[CustomerPII]
    TO [SalesPersons]
GO
GRANT SELECT
    ON [Sales].[CustomerPII]
    TO [SalesManagers]
GO
GRANT SELECT
    ON [Sales].[CustomerPII]
    TO [SalesPersons]
GO
GRANT UPDATE
    ON [Sales].[CustomerPII]
    TO [SalesManagers]
GO
GRANT UPDATE
    ON [Sales].[CustomerPII]
    TO [SalesPersons]
GO

Collapse image See also


List of tables