Table:
[AdventureWorks2016CTP3].[Sales].[CustomerPII]
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 |
Creation options
| Name | Value |
| QUOTED_IDENTIFIER | ON |
| ANSI_NULLS | ON |
| ANSI_PADDING | ON |
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 | ![]() |
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 |
Permissions
| User/role | Alter | Control | Select | Insert | Update | Delete | DRI | Take ownership | View definition | Columns | ||
| [dbo].[SalesManagers] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Columns |
| [dbo].[SalesPersons] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | Columns |
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 |
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 |
See also