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


Get a list of all tables and fields per table for mounting a tree...
View
Options
Author
Message
Marcio Valerio Silva
Marcio Valerio Silva
Marcio Valerio Silva
posted 13 Years Ago
StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 reputation)StrataFrame Novice (81 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
Reply Like 3
Ivan George Borges
Ivan George Borges
Ivan George Borges
posted 13 Years Ago
Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K 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
Reply Like 2
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...



Submit

Similar Topics

Post Quoted Reply
Reading This Topic

Powered by InstantForum 2017-1 Final © 2024
Execution: 0.000. 3 queries. Compression Enabled.

Login

Explore
Messages
Mentions
Search