Reading Details of the Columns in a Table

Column details for the Orders table in the Northwind database:

COLUMN NAMECustomerIDEmployeeIDFreightOrderDateOrderIDRequiredDateShipAddressShipCityShipCountryShipNameShippedDateShipPostalCodeShipRegionShipVia
ORDINAL POSITION2384151011149613127
COLUMN DEFAULT(0)
IS NULLABLEYESYESYESYESNo YESYESYESYESYESYESYESYESYES
DATA TYPEncharintmoneydatetimeintdatetimenvarcharnvarcharnvarcharnvarchardatetimenvarcharnvarcharint
CHARACTER MAXIMUM LENGTH5601515401015
CHARACTER OCTET LENGTH101203030802030
NUMERIC PRECISION10192310232310
NUMERIC PRECISION RADIX10101010
NUMERIC SCALE0430330
DATETIME PRECISION333
CHARACTER SET CATALOG
CHARACTER SET SCHEMA
CHARACTER SET NAMEUnicodeUnicodeUnicodeUnicodeUnicodeUnicodeUnicode
COLLATION CATALOG


[view source]     ©2005 Dave And Al.net