View the structure of the table and Alter table
来源:互联网 发布:女博士杀人 知乎 编辑:程序博客网 时间:2024/06/02 04:22
The structure of a table can be viewed using the DESCRIBE TABLE_NAME command. This command shows the entire schema of the table.
2 the limitation of alter command
ALTER Command supports only the RENAME TABLE and ADD COLUMN variants. Other kinds of ALTER TABLE operations such as DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT are omitted
Alter Table command is a DDL command that is used to change the definition of the table. Changing definition means changing datatype, width of columns or adding a new column in the table.
Column can’t be deleted with alter command.
Column can’t be renamed a column.
Column can’t be added in between of the existing columns.
When a column is added, it will be added at the end of the table.
- View the structure of the table and Alter table
- 79.View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CU
- 93.View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, y o
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- 13.View the Exhibit and examine the structure of the PRODUCTS table.
- 44.View the Exhibit and examine the structure of the ORD table.
- 52.View the Exhibit and examine the structure of the PRODUCTS table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- 56.View the Exhibit and examine the structure of the PROMOTIONS table.
- 61.View the Exhibit and examine the structure of the PROMOTIONS table.
- 62.View the E xhibit and examine the structure of the CUSTOMERS table.
- 63.View the Exhibit and examine the structure of the PRODUCTS table.
- 65.View the Exhibit and examine the structure of the CUSTOMERS table.
- 84.View the Exhibit and examine the structure of the EMPLOYEES table.
- 99.View the Exhibit and examine the structure of the PROMOTIONS table.
- 100.View the Exhibit and examine the structure of the PROMOTIONS table.
- 110.View the Exhibit and examine the structure of the CUSTOMERS table.
- CentOS下安装Oracle10g图文教程|Linux安装Oracle10g
- 一个HTML超链接正则表达式的分析过程
- Drop and truncate table command
- (中国最权威的)计算机科学与技术学科排名结果(本次参评院校总数:71)
- acrobat页面显示问题
- View the structure of the table and Alter table
- GFx 阅读摘要
- Magento开发问题汇总
- 你只有到了那个层次,才会有相应的圈子
- CreateThread使用(六个参数介绍)
- mono for android
- 跨dll访问STL
- 模板
- CxImage DLL 链接错误解决方案