Table:
[AdventureWorks2016CTP3].[Sales].[CustomerPII]
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 |
Name | Value |
QUOTED_IDENTIFIER | ON |
ANSI_NULLS | ON |
ANSI_PADDING | ON |
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 | ![]() |
Object name | Object type | Dep level |
[dbo].[SalesManagers] | Role | 1 |
[dbo].[SalesPersons] | Role | 1 |
[Sales] | Schema | 1 |
[dbo].[Name] | Datatype | 1 |
User/role | Alter | Control | Select | Insert | Update | Delete | DRI | Take ownership | View definition | Columns | ||
[dbo].[SalesManagers] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Columns |
[dbo].[SalesPersons] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Columns |
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 |
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 |