Length of Field and default value in the data table

  • Thread starter Thread starter Kuups
  • Start date Start date
K

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 ?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DataGridViewComboBoxColumn Default Value not working 1
Value violates the MaxLength - from combo box 6
Shared functions 1
Data bind problem setting default field values 1
Defining a block of consecutive rows in a datatable 8
Add value to data-bound datagridview during run-time 1
Clr trigger for insert 1
Field Default Value 0

Back
Top