Get a list of all tables and fields per table for mounting a tree view!


Author
Message
Marcio Valerio Silva
Marcio Valerio Silva
StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)StrataFrame Novice (59 reputation)
Group: Forum Members
Posts: 55, Visits: 929
I need to get a list of all tables and fields per table for mounting a tree view with data that will be displayed in a DataGridView, does anyone have any suggestions?

at,

Marcio Valerio da Silva
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Marcio.

Guess the way to go could be through a stored procedure, and then just use T-SQL to get them all. Lots of samples searching the internet, here one of them:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112527
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search