How to delete column and row in table# Database - 数据库
ak
1 楼
How to delete column and row in table (oracle)?
I am a new user. Thanks!
I am a new user. Thanks!
B*z
2 楼
try
ALTER TABLE tableName DROP COLUMN columnName
【在 ak 的大作中提到】
: How to delete column and row in table (oracle)?
: I am a new user. Thanks!
ALTER TABLE tableName DROP COLUMN columnName
【在 ak 的大作中提到】
: How to delete column and row in table (oracle)?
: I am a new user. Thanks!
s*d
3 楼
u need to update the column to null, otherwise the database maybe wont let you
drop that column.
【在 B**z 的大作中提到】
: try
: ALTER TABLE tableName DROP COLUMN columnName
drop that column.
【在 B**z 的大作中提到】
: try
: ALTER TABLE tableName DROP COLUMN columnName
相关阅读
Re: how to improve the performance of Oracle Insert operation?how can i execute pl/sql (or stored procedure) in java??what's the user name and password and host name for Oracle SQL plus?question about sql trigger.WaterReporthow to link to remote access database?Help: Informix , ODBC connection problem请问大侠： superkeyUrgent questionOracle8 安装问题：missing export ORA805.DLL:OCIResetHow to using ODBC to write data to and access data from BLOB type?ASP高人们帮忙看看这几行 SQL codes的问题，谢乐！SQL server vs. DB 2好像偶的Oracle到了极限？怎么用visio画 ER图How to store data locally?Who can give me an example for Select For Update准备考Oracle DBA，不知到哪里可以搞到便宜或免费教材?Oracle Installation Help!!index loss after replication