How to update schema?

181 views Asked by At

Is there any way to update schema? I've created a db with schema now I want to add an index to it. How to add an extra index to existing store?

Thanks, -Kesav

2

There are 2 answers

0
Kyaw Tun On BEST ANSWER

Just change your schema. If you define schema version, remember to increase it.

0
AFetter On

Yes. If you use SQL Server, on management studio you change your table e save the new Schema. Then you run this script.