[RESOLVED] Create Table

[Jagjit]

Hi

I am creating table through coding , i want active field should have default value = "Y"

sql = " CREATE TABLE Test" & "" _
& " (tcode nvarchar(10) NOT NULL Primary Key, " _
& " tname nvarchar(100) NULL," _
& " active nvarchar(1) NULL," _
& ")"
cnn.Execute (sql)

Thanks

[Nightwalker83]

Something along the lines of

INSERT INTO `test` (`tcode`, `tname`, `active`) VALUES
(1, NULL, 'Y');

should work.

[Jagjit]

Hi

I want this during Table Creation , i don't want through Insert statement.

Thanks

[Joacim Andersson]

Moved to the Database Development forum.

[IanRyder]

Hi,

Here you go:-

CREATE TABLE Test (active nvarchar(1) NULL default 'Y')

Hope that helps.

Cheers,

Ian

[Jagjit]

Hi Ryder

Thanks