ALTERVIEW

  • Web修改检视表

Web Definition

1.
修改检视表
...13-3建立检视表（CreateView）13-4修改检视表（AlterView）13-5删除检视表（DropView）13-6常见的视界表格（ViewTable…
shopping.pchome.com.tw|Based on 3 pages

Sample Sentence

Definition:
AllAll,修改检视表修改检视表
Category:AllAll,OralOral,WrittenWritten,TitleTitle,TechnicalTechnical
Source:AllAll,DictionaryDictionary,WebWeb
Difficulty:AllAll,EasyEasy,MiddleMiddle,HardHard
1.
ALTER VIEW can be applied to indexed views; however, ALTER VIEW unconditionally drops all indexes on the view.
ALTERVIEW可应用于索引视图；但是，ALTERVIEW会无条件地删除视图的所有索引。
ALTERVIEW kě yìng yòng yú suǒ yǐn shì tú ; dàn shì , ALTERVIEW huì wú tiáo jiàn de shān chú shì tú de suǒ yǒu suǒ yǐn 。
technet.microsoft.com
2.
ALTER VIEW does not affect dependent stored procedures or triggers and does not change permissions.
ALTERVIEW不影响相关的存储过程或触发器，并且不会更改权限。
ALTERVIEW bù yǐng xiǎng xiāng guān de cún chǔ guò chéng huò chù fā qì , bìng qiě bú huì gēng gǎi quán xiàn 。
technet.microsoft.com
3.
For more information about the parameters used in the ALTER VIEW statement, see CREATE VIEW (Transact-SQL).
有关ALTERVIEW语句中所用参数的详细信息，请参阅CREATEVIEW（Transact-SQL）。
yǒu guān ALTERVIEW yǔ jù zhōng suǒ yòng cān shù de xiáng xì xìn xī , qǐng cān yuè CREATEVIEW ( Transact-SQL ) 。
technet.microsoft.com
4.
If a DROP VIEW followed by a CREATE VIEW is used, instead of ALTER VIEW, permissions on the view would have to be reassigned.
如果使用DROPVIEW后再执行CREATEVIEW，而不是ALTERVIEW，则视图的权限必须重新分配。
rú guǒ shǐ yòng DROPVIEW hòu zài zhí xíng CREATEVIEW , ér bú shì ALTERVIEW , zé shì tú de quán xiàn bì xū chóng xīn fēn pèi 。
www.ianywhere.com
5.
For more information about ALTER VIEW, see Remarks in CREATE VIEW (Transact-SQL).
有关ALTERVIEW的详细信息，请参阅CREATEVIEW（Transact-SQL）中的“备注”部分。
yǒu guān ALTERVIEW de xiáng xì xìn xī , qǐng cān yuè CREATEVIEW ( Transact-SQL ) zhōng de " bèi zhù " bù fen 。
technet.microsoft.com
6.
Encrypts the entries in sys. Syscomments that contain the text of the ALTER VIEW statement.
加密sys.syscomments中包含ALTERVIEW语句文本的项。
jiā mì sys.syscomments zhōng bāo hán ALTERVIEW yǔ jù wén běn de xiàng 。
technet.microsoft.com
7.
Syntax 1 The ALTER VIEW statement is identical in syntax to the CREATE VIEW statement except for the first word.
语法1除第一个单词外，ALTERVIEW语句的语法与CREATEVIEW语句的语法相同。
yǔ fǎ yī chú dì yī gè dān cí wài , ALTERVIEW yǔ jù de yǔ fǎ yǔ CREATEVIEW yǔ jù de yǔ fǎ xiāng tóng 。
www.ianywhere.com
8.
The user must remove that option using ALTER VIEW before defining the INSTEAD OF trigger.
用户必须用ALTERVIEW删除该选项后才能定义INSTEADOF触发器。
yòng hù bì xū yòng ALTERVIEW shān chú gāi xuǎn xiàng hòu cái néng dìng yì INSTEADOF chù fā qì 。
msdn2.microsoft.com
9.
Then, ALTER VIEW is used to replace the view.
然后，使用ALTERVIEW替换该视图。
rán hòu , shǐ yòng ALTERVIEW tì huàn gāi shì tú 。
technet.microsoft.com
10.
If a view currently used is modified by using ALTER VIEW, the Database Engine takes an exclusive schema lock on the view.
如果当前所用的视图使用ALTERVIEW来修改，则数据库引擎使用对该视图的排他架构锁。
rú guǒ dāng qián suǒ yòng de shì tú shǐ yòng ALTERVIEW lái xiū gǎi , zé shù jù kù yǐn qíng shǐ yòng duì gāi shì tú de pái tā jià gòu suǒ 。
technet.microsoft.com