ORACLE_Les09_chinese 创建和管理表.pptVIP

Adding a Comment to a Table You can add a comment of up to 2,000 bytes about a column, table, view, or snapshot by using the COMMENT statement. The comment is stored in the data dictionary and can be viewed in one of the following data dictionary views in the COMMENTS column: ALL_COL_COMMENTS USER_COL_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS Syntax COMMENT ON TABLE table | COLUMN table.column IS text; In the syntax: table is the name of the table column is the name of the column in a table text is the text of the comment You can drop a comment from the database by setting it to empty string (): COMMENT ON TABLE employees IS ; Summary In this lesson, you should have learned how to use DDL commands to create, alter, drop, and rename tables. You also learned how to truncate a table and add comments to a table. CREATE TABLE Create a table. Create a table based on another table by using a subquery. ALTER TABLE Modify table structures. Change column widths, change column data types, and add columns. DROP TABLE Remove rows and a table structure. Once executed, this statement cannot be rolled back. RENAME Rename a table, view, sequence, or synonym. TRUNCATE Remove all rows from a table and release the storage space used by the table. The DELETE statement removes only rows. COMMENT Add a comment to a table or a column. Query the data dictionary to view the comment. 表的注释 使用COMMENT 语句给表或列添加注释 可以通过下列数据字典视图查看所添加的注释: ALL_COL_COMMENTS USER_COL_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS COMMENT ON TABLE employees IS Employee Information; Comment created. 总结 语句 描述 CREATE TABLE 创建表 ALTER TABLE 修改表结构 DROP TABLE 删除表 RENAME 重命名表 TRUNCATE 删除表中的所有数据，并释放存储空间 COMMENT 给对象加注释 通过本章学习，您已经学会如何使用DDL语句创建, 修改, 删除, 和重命名表. Schedule: Timing Topic 30 minutes Lecture 20 minutes Practice 50 minutes Total Lesson Aim In this lesson, you learn about tables, the main database objects, and their relationships to each other. You also learn how