Columns list from a custom table class name

Is there a way through macros or sql to get list of columns of a specified custom table ?

custom table

Novice User - Please check the following custom table macros (Tested from Kentico 12) -

CMSContext.Current.GlobalObjects.CustomTables - it returns list of custom tables
CMSContext.Current.GlobalObjects.CustomTables[0].ClassShowColumns - It returns columns names from first custom table of list

You can also play with macros from System--> Macros --> Console and it is interface to verify all Kentico objects as a Macro.

Reference URLs -

Hope it helps you!!

0 votesVote for this answer Unmark Correct answer

Thank you Vasu that worked. I am also trying to get the columns dynamically and I am trying this to no avail

var index ;
var index = 0;
CMSContext.Current.GlobalObjects.CustomTables[index].ClassShowColumns

Is this even possible in macros expression of a dropdown data source? Its wroking perfectly when I replaced index with 0

0 votesVote for this answer Mark as a Correct answer