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.
| Author |
Topic |
|
gds
Starting Member
29 Posts |
 Posted - 2002-05-27 : 00:03:57
|
| Good day to all of you.Is there a store procedure to get the field description? Or is there a way to get the field description? |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-05-27 : 01:33:10
|
| Check for sp_columns in BOL .you can also query information_Schema.Column view .HTH-------------------------------------------------------------- |
 |
|
|
gds
Starting Member
29 Posts |
Posted - 2002-05-27 : 04:14:46
|
| I already tried to check sp_columns, but the field description was not available. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-05-27 : 08:20:46
|
| Did you tried Information_Schema.Column view. what do you mean by field description? . if you are looking for its datatype length and stuff. Information_schema.column view will help you.-------------------------------------------------------------- |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
gds
Starting Member
29 Posts |
Posted - 2002-05-27 : 22:05:44
|
| Thanks Merkin. You've got it right...I saw the script once here, but I couldn't find it again. That's why I post a message. I will be needing this in creating dynamic reports. Instead of Typing the column description in the program. I'll just get it in the table info. So that whenever I change my fields. I have no problem assigning its description in the program..thanks again. |
|
|
|
|
|
|
Getting Field Description
(hint hint)