alter table 中文意思是什麼
alter table
解釋
修改表-
This means long - term blocking table locks are not held and queries or updates to the underlying table can continue during the alter index reorganize transaction
這意味著不保留長期阻塞的表鎖,且對基礎表的查詢或更新可以在alter index reorganize事務處理期間繼續。 -
Checksum cannot validate tables with column filters, or logical table structures where column offsets differ due to alter table statements that drop or add columns. data in
校驗和無法驗證帶有列篩選器的表或列偏移量不一致的邏輯表結構(由於存在用於刪除或添加列的alter table語句) 。 -
The checksum routines released in sql server version 7. 0 cannot validate tables with column filters, or logical table structures where column offsets differ due to alter table statements that drop or add columns
在sql server 7 . 0版中發布的校驗和常式無法驗證帶有列篩選器的表或列偏移量不一致的邏輯表結構(由於存在用於刪除或添加列的alter table語句) 。 -
The alter index statement can be used to rebuild an index part of a constraint definition ; the constraint does not have to be dropped and added again with alter table
Alter index語句可用於重新生成約束定義的索引部分;而不必再使用alter table來刪除和添加約束。 -
Alter table operates as if arithabort is set to on
Alter table的操作方式與arithabort設置為on時相同。 -
Use session user with default constraints in either the create table or alter table statements, or use it as any standard function
Session _ user可在create table或alter table語句中與default約束一起使用,或者將它用作任何標準函數。 -
In addition to performing switch operations that involve partitioned tables, alter table can be used to change the state of the columns, constraints, and triggers of a partitioned table just like it is used for nonpartitioned tables
除了執行涉及到已分區表的switch操作外, alter table還可用於更改已分區表的列、約束和觸發器的狀態,就像它用於非分區表一樣。 -
In sql server 2005 enterprise edition, the number of processors employed to run a single alter table add index based constraint or drop clustered index constraint statement is determined by the
配置選項和當前工作負荷,確定運行單個alter table add (基於索引) constraint或drop (聚集索引) constraint語句採用的處理器數。 -
The restrictions that apply to alter table statements on tables with schema - bound views are the same as the restrictions currently applied when modifying tables with a simple index
應用於包含架構綁定視圖的表的alter table語句的限制,與當前修改包含簡單索引的表時應用的限制相同。 -
If there are any execution plans in the procedure cache that reference the table, alter table marks them to be recompiled on their next execution
如果過程緩存中存在引用表的執行計劃, alter table會將這些執行計劃標記為下次執行時重新編譯。 -
Alter table permissions apply to both tables involved in an alter table switch statement
Alter table權限適用於alter table switch語句涉及的兩個表。 -
Alter table when used to do the following
用於執行以下操作的alter table : -
Generates alter table statements when scripting constraints
在編寫約束腳本時生成alter table語句。 -
The changes specified in alter table are implemented immediately
Alter table語句指定的更改將立即實現。 -
Clause of alter table
子句中指定其他索引選項。 -
Grant alter table permission to the user on all tables that are affected by the
進程影響的所有表的alter table權限授予用戶。 -
Option of alter table, and using the with check option to validate them
選項重新啟用約束檢查,並使用with check選項對其進行驗證。 -
In addition, alter table permission is required if any of the following is true
此外,如果下列任何一條件成立,則要求具備alter table權限: -
Such constraints are ignored until they are re - enabled by using alter table
Check constraint all語句重新啟用這些約束之前,將忽略這些約束。 -
If a null parameter value is passed and that parameter is used in a create table or alter table statement in which the referenced column does not allow null values, the database engine generates an error
如果傳遞null參數值並且在create或alter table語句中使用該參數,而該語句中被引用列又不允許使用空值,則數據庫引擎會產生一個錯誤。
分享友人