在数据表Student中增加字段时,出现如下提示:
The following tables will be saved to your database.Do you want to continue?
提示外键相关的数据表被保存
点"Yes"确定后,出现:'Student' table
- Warning: The following schema-bound objects will be modified:
- Function 'dbo.GetStudentClass': schema binding will be removed.但实际上Student表中并没有用到GetStudentClass函数,只是相关的表中有用到。
此时若确定执行,是否会影响数据库已有设置?
The following tables will be saved to your database.Do you want to continue?
提示外键相关的数据表被保存
点"Yes"确定后,出现:'Student' table
- Warning: The following schema-bound objects will be modified:
- Function 'dbo.GetStudentClass': schema binding will be removed.但实际上Student表中并没有用到GetStudentClass函数,只是相关的表中有用到。
此时若确定执行,是否会影响数据库已有设置?
'dbo.GetStudentClass'
把它的脚本拷贝出来
等改完表后,在看看这个函数,如果变了就重新创建
'Student' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot ALTER 'GetStudentClass' because it is being referenced by object 'Student_TMP'.完全不允许添加字段。