Description
Properties
| Name | Value |
|---|---|
| Collation | |
| File Group | |
| Filestream File Group | |
| Is Partitioned | False |
| Partitioned Column | |
| Partition Scheme | |
| File Groups | |
| Filestream Partition Scheme | |
| Filestream File Groups | |
| Heap | False |
| Full Text Catalog | |
| Full Text | |
| Compression | NONE |
| Row Count (~) | 41041 |
| Created | 5/3/2013 08:15:33 |
| Last Modified | 11/18/2016 23:31:24 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CAR | varchar | 26 | 0 | 0 | True |
False |
False |
||||
|
|
DokKd | varchar | 3 | 0 | 0 | True |
False |
False |
||||
|
|
DokNo | varchar | 25 | 0 | 0 | True |
False |
False |
||||
| DokTg | date | 3 | 10 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK__tblBC23D__5CC52DFDAC2C0741 | CAR, DokKd, DokNo | True |
SQL Script
CREATE TABLE dbo.tblBC23Dok (
CAR varchar(26) NOT NULL,
DokKd varchar(3) NOT NULL,
DokNo varchar(25) NOT NULL,
DokTg date NULL,
PRIMARY KEY CLUSTERED (CAR, DokKd, DokNo) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
CAR varchar(26) NOT NULL,
DokKd varchar(3) NOT NULL,
DokNo varchar(25) NOT NULL,
DokTg date NULL,
PRIMARY KEY CLUSTERED (CAR, DokKd, DokNo) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
No items found