How to delete column and row in table - Database版 - 未名存档

本页内容为未名空间相应帖子的节选和存档，一周内的贴子最多显示50字，超过一周显示500字访问原贴

Database版 - How to delete column and row in table

相关主题
● %如何把一个table所有的column都选出来%	● 初级问题
● SQL Server Trigger on System Base Table or Catalog View	● Basic oracle questions.
● another question--怎么delete a row from a table	● Please help: Innodb table could not drop a column
● 请教如何用alter table 来加一个not null的列	● Re: Please help: Innodb table could not
● 有包子！sql procedure 来rank不同table里面的数据	● How to drop a column from a table in DB2
● 如何only update the first occurrence in a table	● sql server 面试题（9）
● [转载] what's wrong with this PL/SQL	● SQL问题请教: add one more column
● 请教oracle sql query question	● 这个sql怎么写？

相关话题的讨论汇总
话题: column话题: table话题: delete话题: row话题: drop

进入Database版参与讨论

1

(共1页)

ak 发帖数: 512	1 How to delete column and row in table (oracle)? I am a new user. Thanks!
B**z 发帖数: 153	2 try ALTER TABLE tableName DROP COLUMN columnName 【在 ak 的大作中提到】 : How to delete column and row in table (oracle)? : I am a new user. Thanks!
s****d 发帖数: 13	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

1

(共1页)

进入Database版参与讨论

相关主题
● 这个sql怎么写？	● 有包子！sql procedure 来rank不同table里面的数据
● truncate和delete在ORACLE里有什么区别?	● 如何only update the first occurrence in a table
● thanks:Re: How to delete column and row	● [转载] what's wrong with this PL/SQL
● sql请教	● 请教oracle sql query question
● %如何把一个table所有的column都选出来%	● 初级问题
● SQL Server Trigger on System Base Table or Catalog View	● Basic oracle questions.
● another question--怎么delete a row from a table	● Please help: Innodb table could not drop a column
● 请教如何用alter table 来加一个not null的列	● Re: Please help: Innodb table could not

相关话题的讨论汇总
话题: column话题: table话题: delete话题: row话题: drop

未名新帖统计// 7月16日

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

* 这里只显示发帖超过25的版面，努力灌水吧:-)