Created a new table in SQLServer. Need to see the table structure and data in SSMS.
When I execute
<code>select * from information_schema.tables
</code>
<code>select * from information_schema.tables
</code>
select * from information_schema.tables
I see
| table_catalog | table_schema | table_name | table_type |
|---|---|---|---|
| master | dbo | CustomerData | BASE TABLE |
I dont see this table in SSMS under
SQLServer16.0.1115.1-> Databases-> System Databases-> master-> Tables-> System Tables
I see other tables from dbo under the same tree for example dbo.spt_monitor
I have downloaded and installed SQLServer and SQLServer Management Studio.
SQL Server Version:
Microsoft SQL Server 2022 (RTM-GDR) (KB5035432) – 16.0.1115.1 (X64) Mar 15 2024 01:13:46 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 (Build 19045: ) (Hypervisor)
SSMS Version
20.0.70.0