O
Ozz
I have Master Table(master) and Detail Table(detail)
How can i get master and detail table definition (columns
,indexes,key,etc..)
I know only name of the master and detail table ..
And i dont know relation between two table..
Only thing that i know is Tables' name....
by INFORMATION_SCHEMA.xxxx (in SQL server ) i can access information but it
is not easy..
in ADO.NET how can I do this easily..
I want XMLDocument like that ...
<a>
<table name=master>
<column index="true" PK="true" name="ID" type="int" />
<column index="true" PK="false" name="DetailId type="int">
<table name="detail">
<column index="true" PK="true" name="DetailId"
type="int" />
<column index="true" PK="false" name="DetailName"
type="nvarchar(30)" />
</table>
/column>
</a>
How can i get master and detail table definition (columns
,indexes,key,etc..)
I know only name of the master and detail table ..
And i dont know relation between two table..
Only thing that i know is Tables' name....
by INFORMATION_SCHEMA.xxxx (in SQL server ) i can access information but it
is not easy..
in ADO.NET how can I do this easily..
I want XMLDocument like that ...
<a>
<table name=master>
<column index="true" PK="true" name="ID" type="int" />
<column index="true" PK="false" name="DetailId type="int">
<table name="detail">
<column index="true" PK="true" name="DetailId"
type="int" />
<column index="true" PK="false" name="DetailName"
type="nvarchar(30)" />
</table>
/column>
</a>