dbo.ccs_branch

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 (~)	1
Created	11/19/2012 05:21:03
Last Modified	11/18/2016 23:33:49

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_br	int	4	10	0	True	1 - 1	False	False
br_name	varchar	255	0	0	False		False	False
br_address	varchar	255	0	0	False		False	False
br_alias	varchar	75	0	0	False		False	False
br_code	varchar	3	0	0	False		False	False
br_address2	varchar	75	0	0	False		False	False
br_City	varchar	30	0	0	False		False	False
br_PostCode	varchar	5	0	0	False		False	False
br_AreaCode	varchar	4	0	0	False		False	False
br_Phone_No	varchar	15	0	0	False		False	False
br_Fax_No	varchar	15	0	0	False		False	False
br_CPerson	varchar	15	0	0	False		False	False
br_Email	varchar	100	0	0	False		False	False
br_Createdby	varchar	15	0	0	False		False	False
br_Createdon	datetime	8	23	3	False		False	False
br_Updatedby	varchar	15	0	0	False		False	False
br_Updatedon	datetime	8	23	3	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__ccs_bran__00B7D1181CF15040	id_br	True

SQL Script

CREATE TABLE dbo.ccs_branch (
  id_br int IDENTITY,
  br_name varchar(255) NULL,
  br_address varchar(255) NULL,
  br_alias varchar(75) NULL,
  br_code varchar(3) NULL,
  br_address2 varchar(75) NULL,
  br_City varchar(30) NULL,
  br_PostCode varchar(5) NULL,
  br_AreaCode varchar(4) NULL,
  br_Phone_No varchar(15) NULL,
  br_Fax_No varchar(15) NULL,
  br_CPerson varchar(15) NULL,
  br_Email varchar(100) NULL,
  br_Createdby varchar(15) NULL,
  br_Createdon datetime NULL,
  br_Updatedby varchar(15) NULL,
  br_Updatedon datetime NULL,
  PRIMARY KEY CLUSTERED (id_br) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found