How to get all column name in database using CDatabase?
-
hi all, i am using CDatabase to open the database and its function ExecuteSQL to execute the query. here how can i get all column name list of current database. please help me for this. thanks in advance.
-
hi all, i am using CDatabase to open the database and its function ExecuteSQL to execute the query. here how can i get all column name list of current database. please help me for this. thanks in advance.
Hmm CDatabase looks like a wrapper class around a connection - a C++ one at that! It will depend on your database and your permissions but in sql server there are the system information views and the sysobjects table. These will supply all the system information you need. This may be useful System view mapping[^]
Never underestimate the power of human stupidity RAH
-
Le@rner wrote:
get all column name list of current database.
Did you mean get all column name list of current table.
I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.