Menu
I can use " Microsoft.SqlServer.Management.Smo.Table " in C# to get a table columns of a Sql Server 2005 database.
I have got the column.Name, but how can I get the column's Description in C#?
I have saw the link: SQL Server: Extract Table Meta-Data (description, fields and their data types)
But how can I use C# "Microsoft.SqlServer.Management.Smo" dll to get a column's Description?
585
C programming language is a machine-independent programming language that is mainly used to create many types of applications and operating systems such as Windows, and other complicated programs such as the Oracle database, Git, Python interpreter, and games and is considered a programming foundation in the process of ...
C is a general-purpose language that most programmers learn before moving on to more complex languages. From Unix and Windows to Tic Tac Toe and Photoshop, several of the most commonly used applications today have been built on C. It is easy to learn because: A simple syntax with only 32 keywords.
To start using C, you need two things: A text editor, like Notepad, to write C code. A compiler, like GCC, to translate the C code into a language that the computer will understand.
-= Subtract AND assignment operator. It subtracts the right operand from the left operand and assigns the result to the left operand. C -= A is equivalent to C = C - A.
Say your Smo.Table object is named t.
This will get the description:
t.Columns["ProductID"].ExtendedProperties["MS_Description"].Value
Why don't you use the result from the query described in the link you gave?
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
