Remove/Rename a Field from Schemaless Table?

[webdastur]

Remove/Rename a Field from Schemaless Table?

[dodanex]

Hi @webdastur ,

I'm quoting from the documentation, nodejs/javascript:

TO REMOVE ( https://surrealdb.com/docs/integration/libraries/nodejs#delete ):

// Delete all records from a table
await db.delete('person');
// Delete a specific record from a table
await db.delete('person:h5wxrf2ewk8xjxosxtyc');

TO RENAME ( https://surrealdb.com/docs/integration/libraries/nodejs#modify ):

// Update all records in a table
let people = await db.modify('person', [
	{ op: "replace", path: "/created_at", value: new Date() },
]);
// Update a record with a specific ID
let person = await db.modify('person:tobie', [
	{ op: "replace", path: "/settings/active", value: false },
	{ op: "add", "path": "/tags", "value": ["developer", "engineer"] },
	{ op: "remove", "path": "/temp" },
]);

Please take a deeper look into the docs and see if it helps you!

[webdastur]

I want to rename or delete a field from the table like:
Table User has a name, phone, and password. I want to change the name to full_name.

[MattPhantastic]

How do you do this with plain SurrealQL? I.e. not with JS.

[macjuul]

@webdastur I haven't figured out renaming however deleting a field appears to be as easy as setting it to none

UPDATE users SET name = NONE;

[AceofSpades5757]

For anyone who might stumble across this, I found you can essentially copy a field and then delete the old one. I think there's some way to do this using ALTER, but I haven't figured that out yet.

UPDATE my_table SET new_name = my_field;
UPDATE my_table SET my_field = NONE;

Warning

Trying to assign your field a new name by doing something like UPDATE my_table SET my_field = new_name; will delete your field as if you'd used NONE.

Transactions also appear to be having issues at the moment as I keep getting errors using CANCEL and COMMIT statements. It'll say something like ['The database encountered unreachable logic: crates\\core\\src\\sql\\statement.rs:193: Unexpected statement type encountered: Commit(CommitStatement)']

[webdastur]

@tobiemh I need your help, please!