Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
Querying Object Information from SQL Server Database, Like stored proc, viewa, functions, triggeres and more.......
David Smith
Apr 6 2012 12:27 PM
1.7k
Reply
I have a task to basically write an C sharp application to basically tell the user about the an specific SQL SERVER Database.
Lets Say the Database Name is CSharpCorner.mdb. My goal is to add this function or capability to an existing winform application for all new Software Engineers that the company hires that may work or used the database, to simply give a quick helpful tutorial of whats going on behind the scenes. Below is the first set of requirments. C sharp corner lets accomplished Section A below first, and then as we are working or completing the task below, we can add to or give suggestions to this task. Lets start on section A First then we will work on the next section.
Requirements:
Section A:
1. Query a list of all stored procedures
2. Query a list of List all Views
3. Query a list of List all triggers
4. Query a list of List all functions
Section B:
1. For all or each Stored Procedures being used Query CSharpCorner.mdb for list of all tables that are being affected
2. For all or each Views being used Query CSharpCorner.mdb for list of all tables that are being affected
3. For all or each Triggers being used Query CSharpCorner.mdb for list of all tables that are being affected
4. For all or each Function being used Query CSharpCorner.mdb for list of all tables that are being affected
Section C:
1. For I want to create Diagram and then
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
How to compare whether two timings are equal or not in SQL Server
Clustered Indexes