Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

[Added] Objects: Alter Database Column (nuBuilder 4.7.x)

Information about updates, news, Code Library
admin
Site Admin
Posts: 2813
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

[Added] Objects: Alter Database Column (nuBuilder 4.7.x)

Unread post by admin »

You can now alter a database column directly from the Objects Form — no need to open external tools like phpMyAdmin or Adminer anymore!


alter_db_column.png

What you can do:
  • Change a column name (aka Object ID)
  • Modify the data type or size (e.g. change varchar(80) to varchar(120))
  • Make a column nullable or not etc.

How to use it:
  1. Go to the Object Form to view an Object.
  2. Click the Alter database column icon (the gear with a pencil).
  3. A form with an editor will open with an ALTER TABLE statement.
  4. Edit the SQL as needed (e.g. rename a column, change datatype).
  5. Click Run to apply the change directly to the database.

This makes updating your table structure easier and faster — all within nuBuilder itself!
You do not have the required permissions to view the files attached to this post.
Post Reply