SQL

get a list of table names and field names from SQL

     SELECT
          TABLE_SCHEMA AS TABLE_SCHEMA
         ,TABLE_NAME AS TABLE_NAME
         ,COLUMN_NAME AS COLUMN_NAME
     FROM INFORMATION_SCHEMA.COLUMNS

    --Where COLUMN_NAME Like '%Put_Your_Comumn_Name_HERE%' 
        
     ORDER BY
          TABLE_SCHEMA
         ,TABLE_NAME
         ,COLUMN_NAME;

Get all table names in SQL

SELECT name, crdate FROM SYSOBJECTS WHERE xtype = 'U';
-- or 
SELECT * FROM INFORMATION_SCHEMA.TABLES
-- or 
SELECT * FROM databaseName.INFORMATION_SCHEMA.TABLES;

get table column names sql

SELECT      COLUMN_NAME AS 'ColumnName'
FROM        INFORMATION_SCHEMA.COLUMNS 
WHERE 
TABLE_NAME LIKE '%assembly_armatureassy_tbl%' 
and COLUMN_NAME LIKE '%supplied%'