using System;
using System.Data;
using System.Data.Odbc;

namespace OdbcTest
{
    class Program
    {
        static void Main(string[] args)
        {
            OdbcConnection connection = new
OdbcConnection("DSN=FireHazardGames");
            connection.Open();

            OdbcCommand cmd = connection.CreateCommand();
            cmd.CommandText = "SELECT * FROM Posts";
            cmd.CommandType = CommandType.Text;

            OdbcDataAdapter adapter = new OdbcDataAdapter(cmd);

            DataTable schemaTable = new DataTable("Posts");
            adapter.FillSchema(schemaTable, SchemaType.Mapped);

            foreach (DataColumn column in schemaTable.Columns)
            {
                Console.WriteLine
                (
                    column.ColumnName + ":"
                    + " AllowDBNull=" + column.AllowDBNull.ToString()
                    + ", AutoIncrement=" + column.AutoIncrement.ToString()
                    + ", Unique=" + column.Unique.ToString()
                );
            }

            if (schemaTable.PrimaryKey.Length == 0)
                Console.WriteLine("\nNo primary key is defined for table
Posts.");

            schemaTable.Dispose();

            adapter.Dispose();
            cmd.Dispose();

            connection.Close();
            connection.Dispose();

            Console.WriteLine("\n\nPress any key to exit.");
            while (!Console.KeyAvailable)
            {
            }
        }
    }
}