When Can Columns in Table not be Altered and not be Added?

i seem to be getting paranoid over 2 cases listed below. Can someone provide a general list of conditions for:

when can columns not be added to an existing table

when can columns not be altered

Please skip the reason for same name for either case.

---

When can these things not happen? When the user trying to do them doesn't have permissions. Users should in general never have these permissions.(incidentally developers should not have prod permissions to do this sort of thing, so that all changes must be deployed with a script that is in source control) In SQL server, you also have DDL triggers that can be set up to prevent changes

链接地址: http://www.djcxy.com/p/76294.html

上一篇: 在SQL中向列添加NOT NULL

下一篇: 何时可以在表格中的列不被更改和不被添加？