dm_filestream_non_transacted_handles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
database_id int 4 √ null
object_id int 4 √ null
handle_id int 4 √ null
file_object_type int 4 √ null
file_object_type_desc nvarchar 120 √ null
correlation_process_id varbinary 8 √ null
correlation_thread_id varbinary 8 √ null
file_context varbinary 8 √ null
state int 4 √ null
state_desc nvarchar 120 √ null
current_workitem_type int 4 √ null
current_workitem_type_desc nvarchar 120 √ null
fcb_id bigint 8 √ null
item_id varbinary 892 √ null
is_directory bit 1 √ null
item_name nvarchar 512 √ null
opened_file_name nvarchar 512 √ null
database_directory_name nvarchar 512 √ null
table_directory_name nvarchar 512 √ null
remaining_file_name nvarchar 512 √ null
open_time datetime 16,3 null
flags int 4 √ null
login_id int 4 √ null
login_name nvarchar 512 √ null
login_sid varbinary 85 √ null
read_access bit 1 √ null
write_access bit 1 √ null
delete_access bit 1 √ null
share_read bit 1 √ null
share_write bit 1 √ null
share_delete bit 1 √ null
create_disposition int 4 √ null

Relationships

Close relationships within degrees of separation