f*******h
发帖数: 1269 | 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**T
发帖数: 388 | 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***a
发帖数: 16 | 3 哈哈。
银家要DELETE，捏还INSERT！
just use
DELETE FROM R WHERE .
什么猫猫的db, 怕怕的说。
【在 G**T 的大作中提到】
:
: not sure, maybe u have to insert?
| w*****h
发帖数: 139 | 4 To delete a field, not a record.
【在 m***a 的大作中提到】
: 哈哈。
: 银家要DELETE，捏还INSERT！
: just use
: DELETE FROM R WHERE .
: 什么猫猫的db, 怕怕的说。
| m***a
发帖数: 16 | 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*****e
发帖数: 1700 | 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
| c********x
发帖数: 93 | 7 He asked a question about SQL server, not Mysql.
physically
creat
【在 a*****e 的大作中提到】
: 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 :)
|
|
