. . View → Table Designer SQL-
MODIFY STRUCTURE.
, Ctrl+W Table Designer. : Make structure changes permanent?, .. ?. , Yes. No .
ALTER TABLE ( ).
USE.
:
ALTER TABLE <Employee>
ADD COLUMN Address_2 CHAR (30)
, , Address2, CHAR 30 .
:
ALTER TABLE < >
DROP COLUMN Address_2.
, Table Append New Record CTRL+Y.
APPEND BLANK
, .
: , , . , EXCLUSIVE.
DELETE [<>][WHILE <L>][FOR <L>]
DELETE ALL
.
: DELETE RECORD 2 && 2
DELETE ALL FOR address='' && , address, .
DELETE . . .
PACK ().
, , . , . , .
,
RECALL
,
RECALL ALL.
, , DELETED(). , .T.
, ,
|
|
SET DELETED ON ( SET DELETED OFF).
ZAP.
.
FoxPro , , . , , , (Delete Mark). . Delete Records( ) Table ().
Remove Deleted Records ( ) Table. , . , .