Share via

Table is listed in the sys.tables, but not visible in the SSMS GUI

vsslasd 556 Reputation points
2023-04-17T16:50:24.1633333+00:00

These two tables are listed in the Select * from sys.Tables query, but they are not available in SSMS Table is listed in the sys.tables, but not visible in the SSMS GUI and the sa user account is used in both cases: User's image

How can I delete these two tables ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
Accepted answer
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-04-18T02:04:04.74+00:00

    Hi @vsslasd

    Although the two tables you selected are named dbo_..., they are not in the dbo schema.

    You can use the query statement provided by Dan to view it.

    Best regards,

    Percy Tang

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dan Guzman 9,231 Reputation points
    2023-04-17T22:38:00.0466667+00:00

    These tables are in a schema other than dbo (note the schema_id 6 value). Do you see them in SSMS with the 2-part names returned by this query SELECT SCHEMA_NAME(schema_id) AS SchemaName, name AS TableName FROM sys.tables;

    1 person found this answer helpful.
    0 comments
  2. vsslasd 556 Reputation points
    2023-04-21T13:48:19.96+00:00

    Thank you... They were in the System Tables... they were CDC objects.

    0 comments