alter query for adding description for a column in a table?

Question

0.00/5 (No votes)

See more:

SQL-Server

SQL-Server-2008

any query for alter query for adding description for a column in a table

Posted 16-Oct-13 20:27pm

aravindnass

Add a Solution

Comments

[no name] 17-Oct-13 2:29am

Can you be more clear..??

Tom Marvolo Riddle 17-Oct-13 2:36am

Want to add a column named description?

aravindnass 17-Oct-13 2:59am

noo..I want add description on a column

ArunRajendra 17-Oct-13 2:40am

Are you facing any problem while using "alter table add column" statement?

aravindnass 17-Oct-13 3:00am

I want a query for add description on a column

Mehdy Moini 17-Oct-13 3:28am

why don't you use sys.sp_addextendedproperty?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdy Moini · Answer 1 · 2013-10-16T20:50:00

You can use

SQL

sys.sp_addextendedproperty

SQL

EXEC sys.sp_addextendedproperty
  @name=N'MS_Description'
 ,@value=N'Here is my description!'  --<<<<
 ,@level0type=N'SCHEMA'
 ,@level0name=N'dbo'
 ,@level1type=N'TABLE'
 ,@level1name=N'TABLE_NAME' --<<<<
 ,@level2type=N'COLUMN'
 ,@level2name=N'FIELD_NAME'  --<<<<

for more information look at this link:
http://technet.microsoft.com/en-us/library/ms180047.aspx[^]

alter query for adding description for a column in a table?

1 solution

Solution 1

Add your solution here

Preview 0

alter query for adding description for a column in a table?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us