Get and set column description from sql server2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

Get and set column description from sql server2005

Author

Topic

hamilad
Starting Member

2 Posts

Posted - 2007-08-10 : 09:34:25

I dont know,how can I get column description from Sql Server 2005 and use it in vb.net 2005? would you please help me solve it?

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-10 : 09:55:39

use fn_listextendedproperty

e.g.
SELECT objtype, objname, name, value
FROM fn_listextendedproperty(null, 'SCHEMA', 'dbo', 'table', 'mytablename', 'column', default)

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources