Query below returns a list of all columns in a 'Product' table of 'Sales' database.
SELECT ColumnName FROM DBC.ColumnsV WHERE DatabaseName = 'Sales' AND TableName = 'Product' ORDER BY ColumnID;
- ColumnName - name of a column in a table
- One row represents a single column
- Scope of rows: represent all columns in a named table
- Ordered by column position in table
You could also get this
Get this interactive HTML data dictionary in minutes with Dataedo.