[RESOLVED] Create Table

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

Something along the lines of

sql Code:

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

should work.

Hi

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

Thanks

Moved to the Database Development forum.

Hi,

Here you go:-

Code:

---

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

---

Hope that helps.

Cheers,

Ian

Hi Ryder

Thanks