Avoid NULL columns using DEFAULT Empty String

Question

Hi,

how can I create a Column with the default value being an empty string?

thanks guys!

Answer 1

Something like:

CREATE TABLE foobar (string_column VARCHAR(100) NOT NULL DEFAULT '')

Answer 2

You can read up on the subject here

CREATE TABLE dbo.Test (ID INTEGER, EmptyString VARCHAR(32) DEFAULT '')

INSERT INTO dbo.Test (ID) VALUES (1)
INSERT INTO dbo.Test (ID) VALUES (2)

SELECT * FROM dbo.Test

DROP TABLE dbo.Test