NJC__Documentation::DB

dbo.dt_ms_car_line_group

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 (~) 215
Created 9/11/2017 09:42:00
Last Modified 9/11/2017 09:42:02

Columns

Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
ms_car_line_group_id int 4 10 0

True

1 - 1

False

False

ms_car_line_group varchar 50 0 0

False

False

False

create_date datetime 8 23 3

False

False

False

create_by int 4 10 0

False

False

False

modify_date datetime 8 23 3

False

False

False

modify_by int 4 10 0

False

False

False

Indexes

Key Name Columns Unique Type Description
PK_dt_ms_car_line_group ms_car_line_group_id

True

SQL Script

CREATE TABLE dbo.dt_ms_car_line_group (
  ms_car_line_group_id int IDENTITY,
  ms_car_line_group varchar(50) NULL,
  create_date datetime NULL,
  create_by int NULL,
  modify_date datetime NULL,
  modify_by int NULL,
  CONSTRAINT PK_dt_ms_car_line_group PRIMARY KEY CLUSTERED (ms_car_line_group_id)
)
ON [PRIMARY]
GO

Depends On

No items found