Length of Field and default value in the data table

[Kuups]

Hi! there is a way looking what
is particular property or methods of datatable
does have the length and default
value of the field declared in the
sequel server jus like for example..

Declared in the database table.
Currency ID nvarchar(20), Default Value (a)
Sell rate numeric(18,6) Default Value (0)

What about in the datatable
does it possible to look
for the length and default value for datatable ?

[Dustin Brisebois via DotNetMonster.com]

Re: Length of Field and default value in the data table

You are looking for the SQL syntax of the Column or Table then?

SHOW CREATE TABLE

that is the MySQL syntax for the command I dont not know if its the same or
Microsoft SQL Server.

--
Message posted via http://www.dotnetmonster.com