Reading Details of the Columns in a Table
Column details for the
Orders
table in the
Northwind
database:
COLUMN NAME
CustomerID
EmployeeID
Freight
OrderDate
OrderID
RequiredDate
ShipAddress
ShipCity
ShipCountry
ShipName
ShippedDate
ShipPostalCode
ShipRegion
ShipVia
ORDINAL POSITION
2
3
8
4
1
5
10
11
14
9
6
13
12
7
COLUMN DEFAULT
(0)
IS NULLABLE
YES
YES
YES
YES
No
YES
YES
YES
YES
YES
YES
YES
YES
YES
DATA TYPE
nchar
int
money
datetime
int
datetime
nvarchar
nvarchar
nvarchar
nvarchar
datetime
nvarchar
nvarchar
int
CHARACTER MAXIMUM LENGTH
5
60
15
15
40
10
15
CHARACTER OCTET LENGTH
10
120
30
30
80
20
30
NUMERIC PRECISION
10
19
23
10
23
23
10
NUMERIC PRECISION RADIX
10
10
10
10
NUMERIC SCALE
0
4
3
0
3
3
0
DATETIME PRECISION
3
3
3
CHARACTER SET CATALOG
CHARACTER SET SCHEMA
CHARACTER SET NAME
Unicode
Unicode
Unicode
Unicode
Unicode
Unicode
Unicode
COLLATION CATALOG
[
view source
]
©2005
Dave And Al.net