query to list field data types

From: David Hepburn III (drhepburniii_at_hotmail.com)
Date: 04/19/04

  • Next message: Hugo Kornelis: "Re: query to list field data types" 
    Date: Mon, 19 Apr 2004 10:04:25 -0700

    Can anyone tell me if there's a query command that will
    return information about a table's properties, such as
    field names, field data types, field lengths, index names,
    etc?

    For example, I'm looking for output that would show the
    following, if we queried the Customers table in the MS
    Northwind SQL DB:

    CustomerID, nchar, 5, nulls=no
    CompanyName, nvarchar, 40, nulls=no
    ContactName, nvarchar, 30, nulls=yes

    etc...

    Thanks!!!
    David

  • Next message: Hugo Kornelis: "Re: query to list field data types"

    Relevant Pages