Chapter 16 System Views
1069
SYSSUBSCRIPTIONS system view
CREATE VIEW SYS.SYSSUBSCRIPTIONS
AS
SELECT(select publication_name
FROM SYS.SYSPUBLICATION AS p
WHERE p.publication_id=s.publication_id) AS
publication_name,
(select user_name FROM SYS.SYSUSERPERM AS u
WHERE u.user_id=s.user_id) AS user_name,
subscribe_by,created,started
FROM SYS.SYSSUBSCRIPTION AS s
Presents subscription information, such as the publication name, creation
time, and start time from the SYSPUBLICATION table in a more readable
format.
To Next Page
Loading...