How to find all the column name from a database?
This helpful query will give you the list of tables: SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_nameFROM sys.tables AS tINNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_IDORDER […]