Skip to content

Files

Latest commit

441ef02 · Jan 25, 2022

History

History
47 lines (40 loc) · 3 KB

sys-external-streams.md

File metadata and controls

47 lines (40 loc) · 3 KB
title description keywords services ms.service ms.topic author ms.author ms.reviewer ms.date
sys.external_streams (Transact-SQL) - Azure SQL Edge
Learn about using sys.external_streams in Azure SQL Edge
sys.external_streams, SQL Edge
sql-edge
sql-edge
reference
rothja
jroth
jroth
05/19/2019

sys.external_streams (Transact-SQL)

Returns a row for each external stream object created within the scope of the database.

Column name Data type Description
name sysname Name of the stream. Is unique within the database.
object_id int object identification number for the stream object. Is unique within the database.
principal_id int ID of the principal that owns this assembly
schema_id int ID of the schema that contains the object.
parent_object_id id object identification number for the parent object for this stream. In the current implementation, this value is always null
type char(2) Object type. For stream objects, the type is always 'ES'
type_desc nvarchar(60) Description of the object type. For stream objects, the type is always 'EXTERNAL_STREAM'
create_date datetime Date the object was created.
modify_date datetime Date the object was last modified by using an ALTER statement.
is_ms_shipped bit Object created by an internal component.
is_published bit Object is published.
is_schema_published bit Only the schema of the object is published.
max_column_id_used bit This column is used for internal purposes and will be removed in future
uses_ansi_nulls bit Stream object was created with the SET ANSI_NULLS database option ON
data_source_id int The object ID for the external data source represented by the stream object
file_format_id int The object ID for the external file format used by the stream object. The external file format is required to specify the actual layout of the data referenced by an external stream
location varchar(max) The target for the external stream object. For more information, refer Create External Stream
input_option varchar(max) The input options used during the creation of the external stream. For more information, refer Create External Stream
output_option varchar(max) The output options used during the creation of the external stream. For more information, refer Create External Stream

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See also