dbo.MessagesTable Properties
| Name | Value |
|---|---|
| Owner | dbo |
| Created | 2004-05-31 |
| Located On | PRIMARY |
| Rows | 16 |
| Data Size KB | 8 |
| Index Size KB | 8 |
Columns
| Name | Description | Data Type | Length | NULL | Default | RowGUIDCOL | Computed | |
|---|---|---|---|---|---|---|---|---|
 |
MessageId | int | 4 | |||||
| Title | nvarchar | 250 | ||||||
| Body | nvarchar | 3000 |
Total: 3 column(s)
Indentity Column
| Name | Seed | Increment | Not for Replication |
|---|---|---|---|
| MessageId | 1 | 1 |
Check Constraints
No check constraints exists
Indexes
| Index | Primary | Unique | Clustered |
|---|
Permissions
No direct permissions defined (N.B. Permissions may be inherited from roles
SQL
CREATE TABLE [Messages] ( [MessageId] [int] IDENTITY (1, 1) NOT NULL , [Title] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Body] [nvarchar] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] GO