dbo.enum_ms_file_type

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 (~)	50
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_field_id	bigint	8	19	True	False	False
file_type_id	int	4	10	True	False	False
ordering	int	4	10	False	False	False
nullable	bit	1	1	False	False	False
max_length	int	4	10	False	False	False
source_col	nvarchar	50	0	False	False	False
source_type	nvarchar	50	0	False	False	False
source_type_id	nvarchar	50	0	False	False	False
source_terminator	nvarchar	50	0	False	False	False
source_collation	nvarchar	50	0	False	False	False
result_col_name	nvarchar	50	0	False	False	False
result_type	nvarchar	50	0	False	False	False
result_type_of	nvarchar	50	0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_enum_ms_file_type_field	file_type_field_id	True

Foreign Keys

Name	Columns	Description
FK_enum_ms_file_type_field_enum_ms_file_type	file_type_id

SQL Script

CREATE TABLE dbo.enum_ms_file_type_field (
  file_type_field_id bigint NOT NULL,
  file_type_id int NOT NULL,
  ordering int NULL,
  nullable bit NULL,
  max_length int NULL,
  source_col nvarchar(50) NULL,
  source_type nvarchar(50) NULL,
  source_type_id nvarchar(50) NULL,
  source_terminator nvarchar(50) NULL,
  source_collation nvarchar(50) NULL,
  result_col_name nvarchar(50) NULL,
  result_type nvarchar(50) NULL,
  result_type_of nvarchar(50) NULL,
  CONSTRAINT PK_enum_ms_file_type_field PRIMARY KEY CLUSTERED (file_type_field_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

ALTER TABLE dbo.enum_ms_file_type_field WITH NOCHECK
  ADD CONSTRAINT FK_enum_ms_file_type_field_enum_ms_file_type FOREIGN KEY (file_type_id) REFERENCES dbo.enum_ms_file_type (file_type_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.enum_ms_file_type_field
  NOCHECK CONSTRAINT FK_enum_ms_file_type_field_enum_ms_file_type
GO

Depends On

dbo.enum_ms_file_type

dbo.enum_ms_file_type_field