i need to add before the age field as father name

selvi subramanian

14y1.4k

USE [sample]

/****** Object: Table [dbo].[selvi] Script Date: 09/18/2012 12:37:29 ******/

SET ANSI_NULLS ON

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,

[landmark] [varchar](50) NULL,

[moble] [varchar](50) NULL

) ON [PRIMARY]

SET ANSI_PADDING OFF

i need to add before the age field as father name

6 Replies

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

nallya14y ago
Accepted answer
Read this
http://www.codeproject.com/Questions/399359/insert-a-column-between-columns-in-SQL-Server

for alter and create statement refer This
http://www.techonthenet.com/sql/tables/alter_table.php
0
selvi subramanian14y ago
alter table selvi add age int after name

it throws error in sqlserver as Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'after'.
0
Shivanand Arur14y ago
Check this out...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58912
0
Shivanand Arur14y ago
I think there is no way of adding it using a query, If you want, the create a new table with the new column added in that new table and then write a script to fetch all the row values to add it in the new table and then drop the old table...
0
selvi subramanian14y ago
i need it in query ya .,
0
Shivanand Arur14y ago
Hey, you can add the column like this.... Please follow the following step.

1. In the Object Explorer, Select your database... then select your table and right click on the table.

2. Select Design from the available list (After Right Clicking your table)

3. In the Design mode, to the extreme left of the columns... Right Click on the line and Click on "Insert Column"
0