Loading ...

Get all columns of specific table

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 all the columns of a specific table, we’re here to help you unlock the full potential of your system. Whether it’s a custom feature, integration, or optimization, our team is ready to bring your vision to life. Leave a customization request today and let’s build something extraordinary together!

Be the first to rate this post

  • Currently 0.0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5