Search code examples
sql-servert-sqlreplicationpublish-subscribe

List all tables that are currently published for replication MS-SQL


I need to get a list of all tables that are published for replication from MS-SQL databases. Is there a system stored procedure or a query I could run to generate such a list?


Solution

  • Yes:

    SELECT *
    FROM sys.tables
    WHERE is_replicated = 1
    

    From MSDN for is_replicated field:

    1 = Table is published using snapshot replication or transactional replication.