How to Get Description of Column_Flags by function GetSchema

Question

How to Get Description of Column_Flags by function GetSchema

Mansour_Dalir 2,036

User's image

hi . What are these numbers and how can they be translated?

   Dim cn As New OleDb.OleDbConnection(Conn_String_Access)
        cn.Open()
        Dim dtSheama As New DataTable
        dtSheama = cn.GetSchema("Tables") 'indexes'columns'Tables

Accepted answer

0 additional answers

Your answer

Answer 1

Jiachen Li-MSFT 34,221 Microsoft External Staff

Hi @Mansour_Dalir ,

For details about the meaning of Column_Flags values, see DBSCHEMA_COLUMNS.

        Using connection As New SqlConnection(connectionString)
            connection.Open()

            Dim tableSchema As DataTable = connection.GetSchema("Columns", New String() {Nothing, Nothing, tableName})

            For Each row As DataRow In tableSchema.Rows
                Dim columnName As String = row("COLUMN_NAME").ToString()
                Dim columnFlags As Integer = Convert.ToInt32(row("COLUMN_FLAGS"))

                Console.WriteLine($"Column Name: {columnName}, Column Flags: {columnFlags}")
            Next
        End Using

Best Regards.

Jiachen Li

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Mansour_Dalir 2,036 Reputation points

2024-04-16T04:24:05.4366667+00:00

hi @Jiachen Li-MSFT It is a bit difficult for me. My goal with this question is to reach this answer. Get the names of the columns that were in (Required) mode

Jiachen Li-MSFT 34,221 Microsoft External Staff

Hi @Mansour_Dalir ,

If you want to get all the column names that don't allow null values, please refer to the code below.

Dim requiredColumns As New List(Of String)()

For Each row As DataRow In dtSheama.Rows
    Dim tableName As String = row("TABLE_NAME").ToString()
    
    Dim dtColumns As DataTable = cn.GetSchema("Columns", New String() {Nothing, Nothing, tableName})

    For Each colRow As DataRow In dtColumns.Rows
        If Not CBool(colRow("IS_NULLABLE")) Then
            Dim columnName As String = colRow("COLUMN_NAME").ToString()
            requiredColumns.Add(columnName)
        End If
    Next
Next

Mansour_Dalir 2,036 Reputation points

2024-04-16T08:57:26.29+00:00

hi @Jiachen Li-MSFT This is a good answer for me. Thank

Share via

How to Get Description of Column_Flags by function GetSchema

0 additional answers

Your answer