how to insert a field in a table .

Question

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

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]

GO

SET ANSI_PADDING OFF

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

nallya · Answer

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