dbo.tbl_nohs

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	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	151
Created	10/24/2018 11:26:11
Last Modified	10/29/2018 09:46:29

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_nohs	bigint	8	19	0	True	1 - 1		False	False
nohs	varchar	50	0	0	True			False	False
TrpBm	decimal	9	18	2	False		(0)	False	False
TrpPpn	decimal	9	18	2	False		(0)	False	False
TrpCuk	decimal	9	18	2	False		(0)	False	False
TrpPbm	decimal	9	18	2	False		(0)	False	False
TrpPph	decimal	9	18	2	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	IX_tbl_nohs	id_nohs	True

SQL Script

CREATE TABLE dbo.tbl_nohs (
  id_nohs bigint IDENTITY,
  nohs varchar(50) NOT NULL,
  TrpBm decimal(18, 2) NULL CONSTRAINT DF_tbl_nohs_TrpBm DEFAULT (0),
  TrpPpn decimal(18, 2) NULL CONSTRAINT DF_tbl_nohs_TrpPpn DEFAULT (0),
  TrpCuk decimal(18, 2) NULL CONSTRAINT DF_tbl_nohs_TrpCuk DEFAULT (0),
  TrpPbm decimal(18, 2) NULL CONSTRAINT DF_tbl_nohs_TrpPbm DEFAULT (0),
  TrpPph decimal(18, 2) NULL
)
ON [PRIMARY]
GO

CREATE UNIQUE INDEX IX_tbl_nohs
  ON dbo.tbl_nohs (id_nohs)
  ON [PRIMARY]
GO

Depends On

No items found

Used By

dbo.fn_rpt_in_bc23