Tagged: sql table columns list

List Table Columns in SQL Server

Hello to everyone, In this article, I will give you information about how to list the columns of the tables in the database in SQL Server. Query below lists all table columns in a SQL Server database. SELECT SCHEMA_NAME(tab.schema_id) AS schema_name, tab.name AS table_name, col.column_id, col.name AS column_name, t.name AS...

Don`t copy text!