How to make an schema

[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

[Ashish Kaila]

From visual studio, create a new dataset object and from server explorer
drag and drop the table onto the dataset file.
Ashish

"RayAll" <Ra****@microsft.com> wrote in message
news:OJ****************@TK2MSFTNGP15.phx.gbl...

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

[RayAll]

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
"Ashish Kaila" <so*****@microsoft.com> wrote in message
news:OI**************@tk2msftngp13.phx.gbl...

From visual studio, create a new dataset object and from server explorer
drag and drop the table onto the dataset file.
Ashish

"RayAll" <Ra****@microsft.com> wrote in message
news:OJ****************@TK2MSFTNGP15.phx.gbl...

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