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 | Other
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

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dan Guzman 9,406 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

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.