問題詳情

4.如果表格 T 被其他物件參照，下列何種 SQL 指令不會刪除表格 T？
(A) DROP TABLE T CASCADE;
(B)DROP TABLE T NULL;
(C)DROP TABLE T DEFAULT;
(D) DROP TABLE T RESTRICT;

參考答案

答案：D
難度：適中0.441176
統計：A(10),B(7),C(2),D(15),E(0)

用户評論

【用戶】ted

【年級】小三下

【評論內容】2.1.1.23 F031-13, DROP TABLE statement: RESTRICT clauseMicrosoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:Transact-SQL does not support this feature. The DROP TABLE statement exists in Transact-SQL, but the statement does not support the RESTRICT keyword.https://msdn.microsoft.com/en-us/library/hh544608(v=sql.105).aspx

【用戶】ted

【年級】小三下

【評論內容】2.1.1.23 F031-13, DROP TABLE statement: RESTRICT clauseMicrosoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:Transact-SQL does not support this feature. The DROP TABLE statement exists in Transact-SQL, but the statement does not support the RESTRICT keyword.https://msdn.microsoft.com/en-us/library/hh544608(v=sql.105).aspx