Generate Xml in hierarchical order from DB

Hi

I have a table named UserProfile with following structure :

(TypeIdbigint,TypeNamenvarchar(100),ParentTypeIdbigint)

Have some following sample data :

TypeId TypeName ParentTypeId

1User0

2Artist1

3Singer2

4DJ1

5Band1

6Partner0

7Movies6

8GoodMovies7

9BadMovies7

10Producer6

I want to generate the XML in following form

<Main>

<TypeId>1</TypeId>

<TypeName>User</TypeName>

<ParentTypeId>0</ParentTypeId>

<SubProfiles>

<SubProfile>

<TypeId>2</TypeId>

<TypeName>Artist</TypeName>

<ParentTypeId>1</ParentTypeId>

</SubProfile>

<SubProfile>

<TypeId>4</TypeId>

<TypeName>DJ</TypeName>

<ParentTypeId>1</ParentTypeId>

</SubProfile>

<SubProfile>

<TypeId>5</TypeId>

<TypeName>Band</TypeName>

<ParentTypeId>1</ParentTypeId>

</SubProfile>

</SubProfiles>

</Main>

I am usign CTE for recursive query and then using for xml auto mode to generate xml. But the data is not generating when the parent child relation is in depth level.

Kindly anybody tell me the query so that I can generate the xml in heirarchical order of data.

CREATE FUNCTION dbo.GetProfileSubTree(@.TypeId int)
RETURNS XML
BEGIN RETURN
(SELECT TypeId AS "TypeId",
TypeName AS "TypeName",
ParentTypeId AS "ParentTypeId",
dbo.GetProfileSubTree(TypeId)
FROM UserProfile
WHERE ParentTypeId=@.TypeId
ORDER BY TypeId
FOR XML PATH('SubProfile'),ROOT('SubProfiles'),TYPE)
END

GO

SELECT TypeId AS "TypeId",
TypeName AS "TypeName",
ParentTypeId AS "ParentTypeId",
dbo.GetProfileSubTree(TypeId)
FROM UserProfile
WHERE ParentTypeId=0
ORDER BY TypeId
FOR XML PATH(''),ROOT('Main'),TYPE

|||

Hi,

This solution helps me to generate the heirarchical data

Thanks

|||

Note that SQL Server 2005 has a maximum limit of 32 recursively nested function invocations.

This is mentioned here at

http://msdn2.microsoft.com/en-us/library/ms345137.aspx

Can you suggest any alternate method for unlimited depth?

Generate Xml in hierarchical order from DB

Hi

I have a table named UserProfile with following structure :

(TypeId bigint,TypeNamenvarchar(100),ParentTypeIdbigint)

Have some following sample data :

TypeId TypeName ParentTypeId

1User0

2Artist1

3Singer2

4DJ1

5Band1

6Partner0

7Movies6

8GoodMovies7

9BadMovies7

10Producer6

I want to generate the XML in following form

<Main>

<TypeId>1</TypeId>

<TypeName>User</TypeName>

<ParentTypeId>0</ParentTypeId>

<SubProfiles>

<SubProfile>

<TypeId>2</TypeId>

<TypeName>Artist</TypeName>

<ParentTypeId>1</ParentTypeId>

</SubProfile>

<SubProfile>

<TypeId>4</TypeId>

<TypeName>DJ</TypeName>

<ParentTypeId>1</ParentTypeId>

</SubProfile>

<SubProfile>

<TypeId>5</TypeId>

<TypeName>Band</TypeName>

<ParentTypeId>1</ParentTypeId>

</SubProfile>

</SubProfiles>

</Main>

I am usign CTE for recursive query and then using for xml auto mode to generate xml. But the data is not generating when the parent child relation is in depth level.

Kindly anybody tell me the query so that I can generate the xml in heirarchical order of data.

CREATE FUNCTION dbo.GetProfileSubTree(@.TypeId int)
RETURNS XML
BEGIN RETURN
(SELECT TypeId AS "TypeId",
TypeName AS "TypeName",
ParentTypeId AS "ParentTypeId",
dbo.GetProfileSubTree(TypeId)
FROM UserProfile
WHERE ParentTypeId=@.TypeId
ORDER BY TypeId
FOR XML PATH('SubProfile'),ROOT('SubProfiles'),TYPE)
END

GO

SELECT TypeId AS "TypeId",
TypeName AS "TypeName",
ParentTypeId AS "ParentTypeId",
dbo.GetProfileSubTree(TypeId)
FROM UserProfile
WHERE ParentTypeId=0
ORDER BY TypeId
FOR XML PATH(''),ROOT('Main'),TYPE

|||

Hi,

This solution helps me to generate the heirarchical data

Thanks

|||

Note that SQL Server 2005 has a maximum limit of 32 recursively nested function invocations.

This is mentioned here at

http://msdn2.microsoft.com/en-us/library/ms345137.aspx

Can you suggest any alternate method for unlimited depth?

Generate SQL script which includes table structure & data?

What are the steps that I should follow in order to generate sql script which includes both the table structure and data?

Thanks

Dear perpetualdream,

Use SQL Server Database Publishing Wizard

HTH,

Suprotim Agarwal

|||

thanks... great tool

Generate SQL Script using a DTS

Hi
Each month I back up the structure of our databases by right-clicking
on each database and select Generate SQL Script...

>From the General tab I select script all objects and from the Options
tab I select script database, along with script indexes and script
primary keys.
As we have several databases this can take some time. Is there away to
automate this using a DTS?
Thanks
MattI don't know if DTS is the way to go but you can certainly use DMO to do
this. In fact, the sample code is included with SQL. All you need to do is
modify it to run automatically and then invoke from s DTS package.
Alternatively, you could use the SP_OA family of procedures to do it. At my
last job, we scripted out some objects just this way.
"matt.cottam@.googlemail.com" wrote:

> Hi
> Each month I back up the structure of our databases by right-clicking
> on each database and select Generate SQL Script...
>
> tab I select script database, along with script indexes and script
> primary keys.
> As we have several databases this can take some time. Is there away to
> automate this using a DTS?
>
> Thanks
> Matt
>|||Yes, have a look at SQL DMO library, you could use it within an ActiveX
script in DTS.
"matt.cottam@.googlemail.com" wrote:

> Hi
> Each month I back up the structure of our databases by right-clicking
> on each database and select Generate SQL Script...
>
> tab I select script database, along with script indexes and script
> primary keys.
> As we have several databases this can take some time. Is there away to
> automate this using a DTS?
>
> Thanks
> Matt
>

Generate SQL Script including actual Data

Hi NG
Is there a way to generate an SQL Script that not only includes database
structure but also the content / data of tables ?
helps appreciated
ChristianChristian
BACKUP\RESTORE commnads
"Christian" <chmug@.swissonline.ch> wrote in message
news:e6efCvUUFHA.548@.tk2msftngp13.phx.gbl...
> Hi NG
> Is there a way to generate an SQL Script that not only includes database
> structure but also the content / data of tables ?
> helps appreciated
> Christian
>|||i can't figure out what you're talking about . could you give me some infos
?
Chris
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O1wkL1UUFHA.3944@.tk2msftngp13.phx.gbl...
> Christian
> BACKUP\RESTORE commnads
>
> "Christian" <chmug@.swissonline.ch> wrote in message
> news:e6efCvUUFHA.548@.tk2msftngp13.phx.gbl...
>> Hi NG
>> Is there a way to generate an SQL Script that not only includes database
>> structure but also the content / data of tables ?
>> helps appreciated
>> Christian
>>
>|||Try QALite (Downloadable from the internet), i will provide you with a set
of functions to get additional Insert Statements for the data.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Christian" <chmug@.swissonline.ch> schrieb im Newsbeitrag
news:e6efCvUUFHA.548@.tk2msftngp13.phx.gbl...
> Hi NG
> Is there a way to generate an SQL Script that not only includes database
> structure but also the content / data of tables ?
> helps appreciated
> Christian
>|||Sure
--We perfom a backup of the database
BACKUP DATABASE test TO DISK='C:\mydatabase.bak'
--Now we restore the database with a new name
RESTORE DATABASE test_newname
FROM 'C:\mydatabase.bak'
WITH RECOVERY,
MOVE 'test_data' TO 'D:\Test_data.mdf',
MOVE 'test_log' TO 'D:\Test_log.ldf'
For more details please refer to the BOL
"Christian" <chmug@.swissonline.ch> wrote in message
news:OdSr26UUFHA.3952@.TK2MSFTNGP15.phx.gbl...
> i can't figure out what you're talking about . could you give me some
infos
> ?
> Chris
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O1wkL1UUFHA.3944@.tk2msftngp13.phx.gbl...
> > Christian
> > BACKUP\RESTORE commnads
> >
> >
> > "Christian" <chmug@.swissonline.ch> wrote in message
> > news:e6efCvUUFHA.548@.tk2msftngp13.phx.gbl...
> >> Hi NG
> >>
> >> Is there a way to generate an SQL Script that not only includes
database
> >> structure but also the content / data of tables ?
> >>
> >> helps appreciated
> >>
> >> Christian
> >>
> >>
> >
> >
>|||Ok, downloaded and installed ... but where can i generate an SQL Script ?
My intension / target
i've a database with content. i wan't the whole database structure INCL. the
data i a SQL Script .. i don't wanna backup / restore the database! my
target is to have a SQL-Script!
Christian
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:ee67X9UUFHA.2892@.TK2MSFTNGP14.phx.gbl...
> Try QALite (Downloadable from the internet), i will provide you with a set
> of functions to get additional Insert Statements for the data.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Christian" <chmug@.swissonline.ch> schrieb im Newsbeitrag
> news:e6efCvUUFHA.548@.tk2msftngp13.phx.gbl...
>> Hi NG
>> Is there a way to generate an SQL Script that not only includes database
>> structure but also the content / data of tables ?
>> helps appreciated
>> Christian
>|||My intension / target
i've a database with content. i wan't the whole database structure INCL. the
data i a SQL Script .. i don't wanna backup / restore the database! my
target is to have a SQL-Script!
Christian
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uojSeDVUFHA.928@.TK2MSFTNGP15.phx.gbl...
> Sure
> --We perfom a backup of the database
> BACKUP DATABASE test TO DISK='C:\mydatabase.bak'
> --Now we restore the database with a new name
> RESTORE DATABASE test_newname
> FROM 'C:\mydatabase.bak'
> WITH RECOVERY,
> MOVE 'test_data' TO 'D:\Test_data.mdf',
> MOVE 'test_log' TO 'D:\Test_log.ldf'
> For more details please refer to the BOL
>
> "Christian" <chmug@.swissonline.ch> wrote in message
> news:OdSr26UUFHA.3952@.TK2MSFTNGP15.phx.gbl...
>> i can't figure out what you're talking about . could you give me some
> infos
>> ?
>> Chris
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:O1wkL1UUFHA.3944@.tk2msftngp13.phx.gbl...
>> > Christian
>> > BACKUP\RESTORE commnads
>> >
>> >
>> > "Christian" <chmug@.swissonline.ch> wrote in message
>> > news:e6efCvUUFHA.548@.tk2msftngp13.phx.gbl...
>> >> Hi NG
>> >>
>> >> Is there a way to generate an SQL Script that not only includes
> database
>> >> structure but also the content / data of tables ?
>> >>
>> >> helps appreciated
>> >>
>> >> Christian
>> >>
>> >>
>> >
>> >
>>
>|||DOn´t know how many tables you´ve got... but there is a qay to script a
single table in QA, right click on the Table --> DDL and inserts.
Jens SUessmeyer.
"Christian" <chmug@.swissonline.ch> schrieb im Newsbeitrag
news:eApftPVUFHA.548@.tk2msftngp13.phx.gbl...
> Ok, downloaded and installed ... but where can i generate an SQL Script ?
> My intension / target
> i've a database with content. i wan't the whole database structure INCL.
> the data i a SQL Script .. i don't wanna backup / restore the database! my
> target is to have a SQL-Script!
> Christian
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in message news:ee67X9UUFHA.2892@.TK2MSFTNGP14.phx.gbl...
>> Try QALite (Downloadable from the internet), i will provide you with a
>> set of functions to get additional Insert Statements for the data.
>> HTH, Jens Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>
>> "Christian" <chmug@.swissonline.ch> schrieb im Newsbeitrag
>> news:e6efCvUUFHA.548@.tk2msftngp13.phx.gbl...
>> Hi NG
>> Is there a way to generate an SQL Script that not only includes database
>> structure but also the content / data of tables ?
>> helps appreciated
>> Christian
>>
>|||try the free data and schema scripter from Innovartis. It comes free with the
evaluation of DB Ghost -
http://www.innovartis.co.uk/database_change_management_evaluation.aspx
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Christian" wrote:
> Hi NG
> Is there a way to generate an SQL Script that not only includes database
> structure but also the content / data of tables ?
> helps appreciated
> Christian
>
>

Generate Script With Data

Hi,

Can Anyone tell me how to generate script with all table data from one database.I can generate script with table structure but not with table data.I want to generate with Table data.

Thanks,

Pavan

If you want to take the data with the tables would it not be easier to do a backup and restore of the data?

Or use Sql Servers import functionality to simply import the tables and data you require?

Can you give us more info on this? such as, are you trying to take just single tables over into an existing database? or are you creating a new database?

Do you want all the tables or just a subset of them?

Thanks

Pete

|||

The Database Publishing Wizard will help you script out the data):

DDL –Script Data to file (Database Publishing Wizard)
http://www.microsoft.com/downloads/details.aspx?FamilyID=56e5b1c5-bf17-42e0-a410-371a838e570a&DisplayLang=en

|||I used to write a simple .NET/VB app to do this - extract data from my database tables and generate a text file which contains INSERT statements which can be run together with the script generated for the database schema. Good thing there is this tool available now.

Generate Script including Data

Hello Group:
Is there any way of generate a script which include data and database
structure in SQL SERVER 2000?
Thanks in advance.
Armandohttp://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Armando Ruiz" <armando-ruiz@.telefonica.net> wrote in message
news:OfzTF$7AFHA.1992@.TK2MSFTNGP10.phx.gbl...
> Hello Group:
> Is there any way of generate a script which include data and database
> structure in SQL SERVER 2000?
> Thanks in advance.
> Armando
>|||Hi Armando,
Would you be able to tell us the exact purpose? There are other better ways
to do it.
--
Thanks
Yogish|||Hello and thanks for your quick answers.
I've to update a remote MSDE database, creating 4 new tables and inserting
data.
I can´t use DTS, Export Data, etc., so I'm looking an easy way to update
that database only by 1 step.
Thanks again
Armando
"Yogish" <yogishkamathg@.icqmail.com> escribió en el mensaje
news:E9EBED22-3D66-4DCB-B91E-8DCF5FAE25A8@.microsoft.com...
> Hi Armando,
> Would you be able to tell us the exact purpose? There are other better
ways
> to do it.
> --
> Thanks
> Yogish|||check out DB Ghost - http://www.dbghost.com for scripting, building,
comparing and synchronizing both schema and data optionally using Source
control.
"Armando Ruiz" wrote:
> Hello and thanks for your quick answers.
> I've to update a remote MSDE database, creating 4 new tables and inserting
> data.
> I can´t use DTS, Export Data, etc., so I'm looking an easy way to update
> that database only by 1 step.
> Thanks again
> Armando
>
> "Yogish" <yogishkamathg@.icqmail.com> escribió en el mensaje
> news:E9EBED22-3D66-4DCB-B91E-8DCF5FAE25A8@.microsoft.com...
> > Hi Armando,
> >
> > Would you be able to tell us the exact purpose? There are other better
> ways
> > to do it.
> >
> > --
> > Thanks
> > Yogish
>
>|||Thanks for the reply .
"mark baekdal" <markbaekdal@.discussions.microsoft.com> escribió en el
mensaje news:8F801F86-AD4A-4D1C-90CA-4CC4619D86FB@.microsoft.com...
> check out DB Ghost - http://www.dbghost.com for scripting, building,
> comparing and synchronizing both schema and data optionally using Source
> control.
> "Armando Ruiz" wrote:
> > Hello and thanks for your quick answers.
> >
> > I've to update a remote MSDE database, creating 4 new tables and
inserting
> > data.
> >
> > I can´t use DTS, Export Data, etc., so I'm looking an easy way to update
> > that database only by 1 step.
> >
> > Thanks again
> >
> > Armando
> >
> >
> >
> > "Yogish" <yogishkamathg@.icqmail.com> escribió en el mensaje
> > news:E9EBED22-3D66-4DCB-B91E-8DCF5FAE25A8@.microsoft.com...
> > > Hi Armando,
> > >
> > > Would you be able to tell us the exact purpose? There are other better
> > ways
> > > to do it.
> > >
> > > --
> > > Thanks
> > > Yogish
> >
> >
> >

Generate a normalized XML doc from SQL Server

I'm trying to generate a normalized XML document out of SQL server
that reflects the data
structure of a table.
Eg. This is what I would like to get
<table name='MtFeedback'>
<field name="MtFeedbackIy" type="int"/>
<field name="Title" type="varchar" size="50"/>
<field name="FirstName" type="varchar" size="50"/>
<field name="Surname" type="varchar" size="50"/>
<field name="insertedon" type="datetime"/>
</table>
I have tried two ways of and these are the results. The 1st technique
is close
select
1 as Tag,
null as Parent,
'' as [table!1],
null as [field!2!table-name],
null as [field!2!name],
null as [field!2!type],
null as [field!2!size]
UNION ALL
select
2 as Tag,
1 as Parent,
null as [table!1],
i.TABLE_NAME as [field!2!table-name],
i.COLUMN_NAME as [field!2!name],
i.DATA_TYPE as [field!2!type],
i.CHARACTER_MAXIMUM_LENGTH as [field!2!size]
from
information_schema.columns i
where
table_name = 'MtFeedback'
FOR XML EXPLICIT
<table>
<field table-name="MtFeedback" name="MtFeedbackIy" type="int"/>
<field table-name="MtFeedback" name="Title" type="varchar"
size="50"/>
<field table-name="MtFeedback" name="FirstName" type="varchar"
size="50"/>
<field table-name="MtFeedback" name="Surname" type="varchar"
size="50"/>
<field table-name="MtFeedback" name="insertedon" type="datetime"/>
</table>
The 2nd technique fails totally.
select
1 as Tag,
null as Parent,
i.TABLE_NAME as [table!1!name],
null as [field!2!name],
null as [field!2!type],
null as [field!2!size]
from
information_schema.columns i
UNION ALL
select
2 as Tag,
1 as Parent,
null as [table!1!name],
i.COLUMN_NAME as [field!2!name],
i.DATA_TYPE as [field!2!type],
i.CHARACTER_MAXIMUM_LENGTH as [field!2!size]
from
information_schema.columns i
where
table_name = 'MtFeedback'
FOR XML EXPLICIT
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="MtFeedback"/>
<table name="categories"/>
<table name="categories"/>
<table name="products"/>
<table name="products"/>
<table name="products"/>
<table name="descriptions"/>
<table name="descriptions"/>
<table name="descriptions"/>
<table name="syssegments"/>
<table name="syssegments"/>
<table name="syssegments"/>
<table name="sysconstraints"/>
<table name="sysconstraints"/>
<table name="sysconstraints"/>
<table name="sysconstraints"/>
<table name="sysconstraints"/>
<table name="sysconstraints"/>
<table name="sysconstraints"/>
<table name="dtproperties"/>
<table name="dtproperties"/>
<table name="dtproperties"/>
<table name="dtproperties"/>
<table name="dtproperties"/>
<table name="dtproperties"/>
<table name="dtproperties">
<field name="MtFeedbackIy" type="int"/>
<field name="Title" type="varchar" size="50"/>
<field name="FirstName" type="varchar" size="50"/>
<field name="Surname" type="varchar" size="50"/>
<field name="insertedon" type="datetime"/>
</table>
Cheers Daviddeclare @.tb sysname
set @.tb='MtFeedback'
select
1 as Tag,
null as Parent,
@.tb as [table!1!name],
null as [field!2!name],
null as [field!2!type],
null as [field!2!size]
UNION ALL
select
2 as Tag,
1 as Parent,
i.TABLE_NAME as [table!1!name],
i.COLUMN_NAME as [field!2!name],
i.DATA_TYPE as [field!2!type],
i.CHARACTER_MAXIMUM_LENGTH as [field!2!size]
from
information_schema.columns i
where
table_name = @.tb
FOR XML EXPLICIT
"muesliflakes" <muesliflakes@.yahoo.com.au> wrote in message
news:8deb82de.0406011916.1e8194b3@.posting.google.com...
> I'm trying to generate a normalized XML document out of SQL server
> that reflects the data
> structure of a table.
> Eg. This is what I would like to get
> <table name='MtFeedback'>
> <field name="MtFeedbackIy" type="int"/>
> <field name="Title" type="varchar" size="50"/>
> <field name="FirstName" type="varchar" size="50"/>
> <field name="Surname" type="varchar" size="50"/>
> <field name="insertedon" type="datetime"/>
> </table>
> I have tried two ways of and these are the results. The 1st technique
> is close
> select
> 1 as Tag,
> null as Parent,
> '' as [table!1],
> null as [field!2!table-name],
> null as [field!2!name],
> null as [field!2!type],
> null as [field!2!size]
> UNION ALL
> select
> 2 as Tag,
> 1 as Parent,
> null as [table!1],
> i.TABLE_NAME as [field!2!table-name],
> i.COLUMN_NAME as [field!2!name],
> i.DATA_TYPE as [field!2!type],
> i.CHARACTER_MAXIMUM_LENGTH as [field!2!size]
> from
> information_schema.columns i
> where
> table_name = 'MtFeedback'
> FOR XML EXPLICIT
> <table>
> <field table-name="MtFeedback" name="MtFeedbackIy" type="int"/>
> <field table-name="MtFeedback" name="Title" type="varchar"
> size="50"/>
> <field table-name="MtFeedback" name="FirstName" type="varchar"
> size="50"/>
> <field table-name="MtFeedback" name="Surname" type="varchar"
> size="50"/>
> <field table-name="MtFeedback" name="insertedon" type="datetime"/>
> </table>
> The 2nd technique fails totally.
> select
> 1 as Tag,
> null as Parent,
> i.TABLE_NAME as [table!1!name],
> null as [field!2!name],
> null as [field!2!type],
> null as [field!2!size]
> from
> information_schema.columns i
> UNION ALL
> select
> 2 as Tag,
> 1 as Parent,
> null as [table!1!name],
> i.COLUMN_NAME as [field!2!name],
> i.DATA_TYPE as [field!2!type],
> i.CHARACTER_MAXIMUM_LENGTH as [field!2!size]
> from
> information_schema.columns i
> where
> table_name = 'MtFeedback'
> FOR XML EXPLICIT
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="MtFeedback"/>
> <table name="categories"/>
> <table name="categories"/>
> <table name="products"/>
> <table name="products"/>
> <table name="products"/>
> <table name="descriptions"/>
> <table name="descriptions"/>
> <table name="descriptions"/>
> <table name="syssegments"/>
> <table name="syssegments"/>
> <table name="syssegments"/>
> <table name="sysconstraints"/>
> <table name="sysconstraints"/>
> <table name="sysconstraints"/>
> <table name="sysconstraints"/>
> <table name="sysconstraints"/>
> <table name="sysconstraints"/>
> <table name="sysconstraints"/>
> <table name="dtproperties"/>
> <table name="dtproperties"/>
> <table name="dtproperties"/>
> <table name="dtproperties"/>
> <table name="dtproperties"/>
> <table name="dtproperties"/>
> <table name="dtproperties">
> <field name="MtFeedbackIy" type="int"/>
> <field name="Title" type="varchar" size="50"/>
> <field name="FirstName" type="varchar" size="50"/>
> <field name="Surname" type="varchar" size="50"/>
> <field name="insertedon" type="datetime"/>
> </table>
> Cheers David