Table Properties
Name | Value |
---|---|
Owner | dbo |
Created | 2004-05-31 |
Located On | PRIMARY |
Rows | 1 |
Data Size KB | 8 |
Index Size KB | 56 |
Columns
Name | Description | Data Type | Length | NULL | Default | RowGUIDCOL | Computed | |
---|---|---|---|---|---|---|---|---|
Username | nvarchar | 50 | ||||||
PostId | int | 4 | ||||||
HasRead | bit | 1 |
Total: 3 column(s)
Indentity Column
No identity column exists
Check Constraints
No check constraints exists
Indexes
Index | Primary | Unique | Clustered |
---|---|---|---|
IX_PostsRead | |||
IX_PostsRead_1 | |||
IX_PostsRead_2 |
Permissions
No direct permissions defined (N.B. Permissions may be inherited from roles
SQL
CREATE TABLE [PostsRead] ( [Username] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [PostId] [int] NOT NULL , [HasRead] [bit] NOT NULL CONSTRAINT [DF_PostsReadDateByUser_HasRead] DEFAULT (1) ) ON [PRIMARY] GO