Ni­PDB_log­Client Database

Files

Name Type Size Maxsize Autogrowth File Name

Ni­PDB_log­Client

Data

8,00 MB

unlimited

64,00 MB

C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\Ni­PDB_log­Client.mdf

Ni­PDB_log­Client_log

Log

8,00 MB

2048,00 GB

64,00 MB

C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\Ni­PDB_log­Client_log.ldf

Tables

  • [dbo.Event­Table]

[dbo].[Event­Table]

Properties

Property Value

Collation

Finnish_­Swedish_­CI_­AS

Row Count (~)

0

Created

11:45:55 den 3 juli 2018

Last Modified

11:45:56 den 3 juli 2018

Columns

Key Name Data Type Max Length (Bytes) Allow Nulls Identity
000046

Event­Table_id

int

4

False

1 - 1

result

int

4

True

event

int

4

True

computer

nvarchar(300)

600

True

card

nvarchar(300)

600

True

message

nvarchar(500)

1000

True

time

datetime

8

True

Indexes

Key Name Key Columns Unique
000046

PK_­Event­Table_id

Event­Table_id

True

SQL Script

CREATE TABLE [dbo].[Event­Table]
(
[Event­Table_id] [int] NOT NULL IDENTITY(1, 1),
[result] [int] NULL,
[event] [int] NULL,
[computer] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[card] [nvarchar] (300) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[message] [nvarchar] (500) COLLATE Finnish_­Swedish_­CI_­AS NULL,
[time] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Event­Table] ADD CONSTRAINT [PK_­Event­Table_id] PRIMARY KEY CLUSTERED ([Event­Table_id]) ON [PRIMARY]
GO