How to make an schema

  • Thread starter Thread starter RayAll
  • Start date Start date
R

RayAll

Hi,

I have a table which has 3 forign keys to three other tables.I's to make an
schema out of this table which contains all the constrainsts and all its
relations and also I'l like to have the records from the look-up tables to
be included into that schema.The reason I like the data is that .I want to
pump data into a dataset ,but I want to make sure that no viloation
happens,I mean I want to make sure that when I pump data into the dataset
for the field country code for example ,the related table contains that code
for sure.

Is there somebody who can help me.

Thanks
 
From visual studio, create a new dataset object and from server explorer
drag and drop the table onto the dataset file.
Ashish
 
Can I define an specific format for a column in Schema?
for instance for one column I'd like the data to like this format "dd/dd/dd"
thanks
 
Back
Top