ofrendo
9/7/2016 - 7:58 AM

Select column names of a table

Select column names of a table

SELECT SCHEMA_NAME, TABLE_NAME, COLUMN_NAME, POSITION
		FROM    TABLE_COLUMNS
		WHERE SCHEMA_NAME = 'SCHEMA_NAME' AND TABLE_NAME = 'TABLE_NAME'
		ORDER BY POSITION;