Table Information

[hamidreza_buddy]

Hi. i want to Get information for each table in DataBase. especially i want to get column type and column size. (I want to use OleDb) i used OleDbSchemaGid and some select statements but most of its returns are (null) and doesnt have any useful information.

[Steve S]

From where do you want to use OLEDB? C#, VB.NET, Managed C++ or native code? If the latter, there is stuff in ATL DB Client templates that will help. Steve S Developer for hire

[hamidreza_buddy]

from C# in a Windows form app

[Dinuj Nath]

If your database is SQL Server try looking up Information_Schema views in the books online. Select * from Information_Schema.Tables will give list of all the tables. -- Don't take life seriously because you can't come out of it alive. -Warren Miller (From Monty2[^] bio)

[hamidreza_buddy]

No. I want to use OleDb. I want to write a Program for all kind of Databases like access,Oracle and ... . is there any standard SQL statement for that.

[Mairaaj Khan]

hamidreza_buddy wrote:

No. I want to use OleDb. I want to write a Program for all kind of Databases like access,Oracle and ... . is there any standard SQL statement for that.

You have to create separate connection for each type of database. Regards

_____________________________ Success is not something to wait for, its something to work for.