帮忙翻译如下计算机专业英语?谢谢(50分)

  • 主题发起人 主题发起人 bluesea07
  • 开始时间 开始时间
B

bluesea07

Unregistered / Unconfirmed
GUEST, unregistred user!
请各个高手帮译完下面这段,谢谢!
Using Relational Rules to Prevent Accidental Deletion: Many DBMSs allow you to enforce rules that prevent the dropping of tables that are related to other tables. When these rules are enforced, if you issue a DROP TABLE statement against a table that is part of a relationship, the DBMS blocks the operation until the relationship was removed. It is a good idea to enable these options, if available, to prevent the accidental dropping of needed tables.
Renaming Tables
Table renaming is supported differently by each DBMS. There is no hard and fast standard for this operation. DB2, MySQL, Oracle, and PostgreSQL users can use the RENAME statement. SQL Server and Sybase users can use the supplied sp_rename stored procedure.
The basic syntax for all rename operations requires that you specify the old name and a new name. However, there are DBMS implementation differences. Refer to your own DBMSdo
cumentation for details on supported syntax.
Summary
In this lesson, you learned several new SQL statements. CREATE TABLE is used to create new tables, ALTER TABLE is used to change table columns (or other objects like constraints or indexes), and DROP TABLE is used to completely delete a table. These statements should be used with extreme caution, and only after backups have been made. As the exact syntax of each of these statements varies from one DBMS to another, you should consult your own DBMSdo
cumentation for more information.
 
不是翻译教程吧?
哈哈………
删除表
删除表(彻底删除整个表,而不仅仅是内容)是非常容易的。使用Drop table语句就可以执行表的删除。
输入:
DROP TABLE CustCopy;
分析:
该语句删除CustCopy表(第15课创建的),无需您的确认,同时也不可撤销-执行该语句永久性地删除这个表。
………………
 
兄弟是我的专业英语课的作业,我怎么都译不好,能帮忙译完吗
 
要是我打字快一点就帮你翻译了
 
接受答案了.
 
谢谢给分。帮你译完,也许迟了,你已经完成了[:D]
利用关系性规则(--完整性规则)防止意外性的删除:许多DBMS允许你使用强制性的规则防止删除与其它表存在关联的表。这些规则启用后,如果您对某个关系表请求Drop Table语句,DBMS会阴止该操作,除非这种关系被解除。使用这些选项不失为一个好主意,它将防止删除有用的表。
重命名表
表的重命名被每个DBMS不同程度地支持。尚不存在强制而且快速的标准用于这些操作。DB2、MySQL、Oracle以及PostgreSQL用户可以使用RENAME语句,SQL SERVER和Sybase用户可以使用内置的sp_rename存储过程。
所有重命名操作的基本语法都要求指定原文件名和新文件名,然而,可能还需要不同的参数,请参考使用的DMNS文档以获得支持语法的详情。、
小结
在本课中,您学习了几种新的SQL语句,Create Table用于创建新表,Alter Table用于修改表的列(或其他对象如限制或索引),Drop Table用于完全删除一个表。这些语句应谨慎使用,最好在(对数据库)备份之后进行。至于这些语句的完整语法的详细信息应参考您的DBMS文档。
 

Similar threads

A
回复
0
查看
943
Andreas Hausladen
A
A
回复
0
查看
819
Andreas Hausladen
A
A
回复
0
查看
666
Andreas Hausladen
A
A
回复
0
查看
848
Andreas Hausladen
A
后退
顶部