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.
14,492 questions
{count} votes

Accepted answer
  1. Anonymous
    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 No comments

2 additional answers

Sort by: Most helpful
  1. Dan Guzman 9,401 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 No 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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.