In MS-SQL a field can have a description:
Name: FName
Description: First Name
Can a SqLite - table have the same??
Thank you! Reinhard
+1
A:
I don't think SQLite support that.
An alternative way is to use comments in the create statement, like this
create table foo (
id integer -- field 1
, name text -- field 2
)
then you can get back the create query and see the descriptions.
Example:
select sql from sqlite_master where name = 'foo'
output:
CREATE TABLE foo (
id integer -- field 1
, name text -- field 2
)
Nick D
2010-02-01 13:36:47
Thank you,not an ideal way, but manageable, given that small "restriction" of Sqlite.
reinhard
2010-02-01 14:52:40
Neat trick. I hope I remember that the next time I want to do something like that.
feihtthief
2010-02-04 19:00:16