SQLite: extended field description

In MS-SQL a field can have a description:

Name: FName

Description: First N开发者_如何学JAVAame

Can a SqLite - table have the same??

Thank you! Reinhard

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
)