Tuesday, May 11, 2010

Query to Return All Columns of Table

This Query will returns the all columns of a specified TABLE.


SELECT *

FROM information_schema.COLUMNS CH
WHERE table_name='tblChMyLogins'

No comments:

There was an error in this gadget

About Me

My photo
I am a Postgraduate in Mathematics from Sri Venkateswara University. I made this blog to share and gain knowledge and basically to express myself. The purpose of making this site was also to make my work available at a single point on Internet. I started programming with dBase and FoxPro, then C and C++. I am a developer working with Software Company.

This Day in History