Today I needed to get all columns of specifict table.
SQL which you can use for this purpose is the following:
SELECT COLUMN_NAME 'All_Columns' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Specific table'
Ready to take your Acumatica experience to the next level? Just like uncovering a...
Privacy policy
|
Cookie settings