adding colum to table

[raja]

how i can add a new colum to table without using constant name

[Krishna]

I am not very sure what you mean by "constant name". To add a new column to
an existing table (assuming SQL Server 7.0)

Go to SQL Server Enterprise Manager
Expand the Server and Database
Click Tables
Rignt Click the table you want to add a column
Click Design Table
Enter Column Name, Data Type and other reqd. parameters
Click Save

You must have to have db_ddladmin database role to perform the above.

Cheers.


Krishna Pada Das, MCDBA
Consultant
The Power Of Ten
Sydney, australia


"raja" <raja@classnet.co.il> wrote:
>
>how i can add a new colum to table without using constant name
>
>

[D. Patrick Hoerter]

raja,

If you want to add a dynamically-named column, such as via a
parameterized stored proc, you need something like this:

DECLARE @ColumnName varchar(30)
SET @ColumnName = 'NewColumn'

DECLARE @SQL varchar(255)
SET @SQL = 'ALTER TABLE doc_exa ADD ' + @ColumnName + ' VARCHAR(20)
NULL'

EXECUTE (@SQL)

...this code would add a new column named 'NewColumn', of type varchar,
with length 20, and nullable = True.

Regards,
D. Patrick Hoerter




raja wrote in message <38f9b062$1@news.devx.com>...
>
>how i can add a new colum to table without using constant name
>
>