Feature request: Comments

Problems, tips, hints - all about usage.

Feature request: Comments

Postby jorhoto » Fri Apr 14, 2017 10:01 am

Hi, it just would be great to have a way to add comments to your columns in tables.
E.g.: In the Structure tab of a table, where you see: Name, Data Type, Foreign Key... and additional field to add Comments.

Thanks for this great tool ;)
jorhoto
 
Posts: 13
Joined: Fri Jul 08, 2016 7:59 am

Re: Feature request: Comments

Postby balaji » Sat Apr 15, 2017 2:28 pm

SQLite itself has no provision to store comments in the table definition. So, yes, sqlitestudio can provide you a space to store comments, but those comments will only be visible in the sqlitestudio instance in which the comments were entered (save the comments locally with sqlitestudio like sql entered in the sql editor windows - the latter is also not part of the database itself and can only be seen within the instance of sqlitestudio in which it was entered). Once you copy the sqlite database file to a different computer and open it with sqlitestudio, the comments will be gone.
balaji
 
Posts: 17
Joined: Fri May 20, 2016 4:04 am

Re: Feature request: Comments

Postby Googie » Thu Apr 20, 2017 10:26 pm

Actually comments CAN be stored in database itself:
Code: Select all
$ sqlite3 test.db                                                                                                                                                           
SQLite version 3.11.0 2016-02-15 17:29:24                                                                                                                                                   
Enter ".help" for usage hints.                                                                                                                                                               
sqlite> create table a (x int /* test comment */, y int -- comment
   ...> );
sqlite> select sql from sqlite_master;
CREATE TABLE a (x int /* test comment */, y int -- comment
)


The thing is to interpret them in a smart way. SQLiteStudio will support this some day, but I'm not sure when exactly.
Googie
Site Admin
 
Posts: 790
Joined: Wed Jul 27, 2011 8:04 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 2 guests