How to update the Existance Tables and StoredProcedures or Functions

[bezzad]

When in a server and that database has exist my Tables and StoresProcedures and Functions , have a problem to update my new changed codes on that database. How to know my new codes is equal by database codes or not? How to know my Tables columns equals by database columns? ...

[bezzad]

Maybe ALTER SP and Func in apllication startup is good for this job!

[bezzad]

Create a Function by name GetLastModify() to give a table same a key/value pair dictionary to check the last updates date by existance methods date and if has a new version of stored procedures or functions then update that.