Click here to Skip to main content
15,843,623 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi i have database that have 250 tables and i want to do specific change design in some of tables like renaming column ,changing datatype ,add identity ,changing primary key and add unique key .
I don't want to do in manually in SSMS and run change script i want to do it with program in C# that select database and do the change automatically is it possible to use SMO or is there any better solution i really appreciated for help
thanks in advance

What I have tried:

DependencyTree Class (Microsoft.SqlServer.Management.Smo) | Microsoft Docs[^]
Posted
Comments
F-ES Sitecore 22-Aug-18 7:29am    
Use SSMS to generate the script then write some c# to execute that script.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900