0 votes
26 views
How can we find all the columns of a table using sql query ?
asked Dec 30, 2015 in Computer Science - IT by slow_learner (1,492 points) | 26 views

1 Answer

0 votes
Best answer

We can use the following query :

SELECT        COLUMN_NAME
FROM            INFORMATION_SCHEMA.COLUMNS
WHERE        (TABLE_NAME = 'Contacts')

where Contacts is the table name in this example

 

answered Dec 30, 2015 by slow_learner (1,492 points)