dbo.enum_ms_file

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

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
file_type_id	int	4	10	True	False	False
file_type_name	varchar	50	0	False	False	False
default_folder	varchar	500	0	False	False	False
temp_folder	varchar	500	0	False	False	False
format_folder	varchar	500	0	False	False	False
allow_ext	varchar	100	0	False	False	False
default_sheet	varchar	50	0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_enum_ms_file_type	file_type_id	True

SQL Script

CREATE TABLE dbo.enum_ms_file_type (
  file_type_id int NOT NULL,
  file_type_name varchar(50) NULL,
  default_folder varchar(500) NULL,
  temp_folder varchar(500) NULL,
  format_folder varchar(500) NULL,
  allow_ext varchar(100) NULL,
  default_sheet varchar(50) NULL,
  CONSTRAINT PK_enum_ms_file_type PRIMARY KEY CLUSTERED (file_type_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.enum_ms_file_type