intTypePromotion=1
zunia.vn Tuyển sinh 2024 dành cho Gen-Z zunia.vn zunia.vn
ADSENSE

Altering tables and contraints

Chia sẻ: Ba Toan | Ngày: | Loại File: PDF | Số trang:28

106
lượt xem
18
download
 
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

Once you have created your tables, you can modify their structure by using the ALTER TABLE command. Add columns, modify the column length, add or drop constraints, and enable or disable constraints by using this command. If you want to remove a table, both the rows and the data structure of a table, invoke the DROP TABLE command. Other commands that affect tables that are covered in this lesson are  RENAME, to change a database object name.  TRUNCATE, to remove all rows from a table.  COMMENT, to add a comment about a database object to the data dictionary. All of these commands are data definition commands...

Chủ đề:
Lưu

Nội dung Text: Altering tables and contraints

ADSENSE

CÓ THỂ BẠN MUỐN DOWNLOAD

 

Đồng bộ tài khoản
2=>2