DATA_SOURCE_NAMES

The DATA_SOURCE_NAMES view contains one entry per configured DSN and includes the following:
  • This view contains a default BASE DSN.
  • This view also contains an entry for the ADMIN DSN which is a DSN generated by the system to be used with server administration DDL and system catalog queries. The value of the DATA_SERVICE_NAME column is _SERVER_.
  • If SQL Logging is enabled, this view also shows the SQL_LOG DSN.
The table below lists the columns that are associated with the DATA_SOURCE_NAMES view:
Name
Type
Description
DSN_NAME
VARCHAR(256)
Specifies the unique name of the DSN.
DATA_SERVICE_NAME
VARCHAR(256)
Specifies the unique name of the data service.
DESC
VARCHAR(256)
Specifies the descriptive text.
FORMAT
CHAR(32)
Specifies the format of the content as STANDARD, which is the standard driver connection string.
OWNER_NAME
VARCHAR(256)
Specifies the name of the user that owns the DSN.
OWNER_ID
VARCHAR(256)
Specifies the ID of the user that owns the DSN.
OWNER_TYPE
CHAR(1)
Specifies the owner type as U (User) or R (Role).
DSN_TYPE
VARCHAR(256)
Specifies the DSN type as one of the following:
FEDERATED
NOPROMPT
CONNECT
FILE
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: March 6, 2018