SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Your-Table-Name'
ORDER BY ORDINAL_POSITION
Programming is fun and interesting. As you all know, sometime we programmers stucks in the middle way of coding without getting a solution. Blogs like this will help us to find a path to solve our problems. The contents of this blog are the solutions that I found by myself and from other sources. Sharing such solutions is also interesting. Thank you!
Showing posts with label SQL Table. Show all posts
Showing posts with label SQL Table. Show all posts
Friday, July 1, 2022
SQL query to get all column names of a table - SQL Qury
Subscribe to:
Posts (Atom)