SQLite - How to define Default value of column in Create Table statement taking reference of other column value

Question

I an using SQLite database and wanted to create a table like following:

Create Table EMPLOYEE ( [FirstName] [varchar](50), [LastName] [varchar](50), [FullName] [varchar](150) AS ([FirstName] + ' ' + [LastName]) );

Can it is possible to have Default value of any column (like FullName) referring to values of other columns present in same table.

UPDATED:

I tried forming CREATE TABLE statement using these IFNULL and COALESCE function but every time its failing. How should i write such CREATE TABLE statement which will have computed column. If such Computed column in CREATE statement is not supported then how should i achieve such requirement. Can anybody please give me an example

laalto · Accepted Answer · 2014-03-26 14:16:33Z

4

The DEFAULT value expression must be a constant expression and referring to other column values makes it non-constant.

You can use IFNULL() or COALESCE() when selecting the data to concatenate other column values in case value is null. For example:

SELECT IFNULL(fullname, firstname || ' ' || lastname) ...

answered Mar 26, 2014 at 14:16

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite - How to define Default value of column in Create Table statement taking reference of other column value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related