Link to home
Start Free TrialLog in
Avatar of jisha123
jisha123

asked on

Getting the script of sql server table and stored procedure with out using SQLSMO COM dll from C#

Hi All,
            I am looking for way by which i can get the script of an sql server table and stored procedure from C# code with out using SQLDMO.dll which is a COM object.Please help.

Jisha.
SOLUTION
Avatar of Ashutosh Vyas
Ashutosh Vyas
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jisha123
jisha123

ASKER

Hi,
     Thanks.In this way we get the scripts of Stored Procedure using exec sp_helptext @procedurename, but how can i get the script of a table from code.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial