SQL Server - View Table Metadata, Sql Server

Language: Layout:

--------------------------------------------------------------------------------
-- Create Tables
--------------------------------------------------------------------------------

CREATE TABLE customers
(
  customer_id           INT NOT NULL,
  customer_name         VARCHAR(100),
  customer_invoice_rate DECIMAL(3,2),
  customer_vat_rate     DECIMAL(3,2),
  CONSTRAINT PK_customers PRIMARY KEY (customer_id)
);

CREATE TABLE customer_invoices
(
  invoice_id          INT NOT NULL,
  invoice_customer_id INT NOT NULL,
  invoice_amount      DECIMAL(19,4),
  CONSTRAINT PK_customer_invoices PRIMARY KEY (invoice_id)
);

--------------------------------------------------------------------------------
-- View Table Details
--------------------------------------------------------------------------------
SELECT t.[object_id],
       SCHEMA_NAME(t.[schema_id]) AS [schema_name],
       t.[name]                   AS [table_name],
       c.[column_id],
       c.[name]                   AS [column_name],
       c.[is_nullable],
       tt.[name]                  AS [data_type],
       c.[max_length],
       c.[precision],
       c.[scale]
  FROM sys.tables t
    INNER JOIN sys.all_columns c
       ON c.[object_id] = t.[object_id]
     LEFT JOIN sys.[types] tt
       ON tt.[user_type_id] = c.[user_type_id]
WHERE 1=1
  AND t.[name] LIKE 'customer%'
--AND t.[object_id] = OBJECT_ID('customers', 'U')
ORDER BY t.[name],
       c.[column_id]
;

View schema
Execution time: 0,08 sec, rows selected: 7, rows affected: 0, absolute service time: 0,25 sec, absolute service time: 0,25 sec