SQL Server stupid questions - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

SQL Server stupid questions

SQL Server stupid questions# Database - 数据库

f*h2099-10-19 07:10

1 楼

After I create a table in SQL Server Manager(6.5), I can't delete a field
after I create it. That's very stupid. And how to edit a table contents
just like Access?
Sorry for new hand.

G*T2099-10-19 07:10

2 楼

not sure, maybe u have to insert?

【在 f*******h 的大作中提到】

: After I create a table in SQL Server Manager(6.5), I can't delete a field
: after I create it. That's very stupid. And how to edit a table contents
: just like Access?
: Sorry for new hand.

m*a2099-10-19 07:10

3 楼

哈哈。
银家要DELETE，捏还INSERT！
just use
DELETE FROM R WHERE .
什么猫猫的db, 怕怕的说。

【在 G**T 的大作中提到】

:
: not sure, maybe u have to insert?

w*h2099-10-19 07:10

4 楼

To delete a field, not a record.

【在 m***a 的大作中提到】

: 哈哈。
: 银家要DELETE，捏还INSERT！
: just use
: DELETE FROM R WHERE .
: 什么猫猫的db, 怕怕的说。

m*a2099-10-19 07:10

5 楼

5,if it's the case. then:
CREATE VIEW Faked_table
AS SELECT O.A1, O.A2, .....O.An
FROM Original_table O
here: Faked_table is the target one, and the Origianl_table is the source
table. the A1,....An is whatever you like to conserve fields.
BTW, the FAked_table isn't physically exist. but there is really physically
stored counterpart of each row of the table. It won't show up to the user.
If it's not what u want and you wanna to lose the field totally, just creat
a new table, but it's not a good

【在 w*****h 的大作中提到】

: To delete a field, not a record.

a*e2099-10-19 07:10

6 楼

table alternation is available in MySQL, check the manual.
For Oracle, I am 90% sure it is able to do it, check the manual
yourself bah :)

【在 m***a 的大作中提到】

: 5,if it's the case. then:
: CREATE VIEW Faked_table
: AS SELECT O.A1, O.A2, .....O.An
: FROM Original_table O
: here: Faked_table is the target one, and the Origianl_table is the source
: table. the A1,....An is whatever you like to conserve fields.
: BTW, the FAked_table isn't physically exist. but there is really physically
: stored counterpart of each row of the table. It won't show up to the user.
: If it's not what u want and you wanna to lose the field totally, just creat
: a new table, but it's not a good