how to insert a field in a table .

selvi subramanian

14y1.3k

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[selvi](

[name] [varchar](50) NULL,

[age] [int] NULL,

[address] [varchar](50) NULL,

[department] [varchar](50) NULL,

[course] [varchar](50) NULL,

) ON [PRIMARY]

SET ANSI_PADDING OFF

in this i have to add a field like LANDMARK. how add landmark field in this table

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

nallya14y ago

Accepted answer

ALTER TABLE {TABLENAME} 
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} 
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}