Friday, July 1, 2022

SQL query to get all column names of a table - SQL Qury

 SELECT COLUMN_NAME  
 FROM INFORMATION_SCHEMA.COLUMNS  
 WHERE TABLE_NAME = 'Your-Table-Name'  
 ORDER BY ORDINAL_POSITION  

No comments:

Post a Comment