How Can i script the contents of table ?

Hi,
I was wondering if there was a function in SMO to script the entire contents of a table.

What I would like to achieve is to select the table in my App and give an option to script the entire contents of the table including primarykeys constraint etc.
Any suggestions would be very much appreciated.

Thanks

[322 byte] By [vbjunkie] at [2008-1-23]

«« Using controls to display info from a table.
»» Generating thumbnails for video files?

# 1

Try various scripting options (properties of the ScriptOption class), such as ScriptOption.Default + ScriptOption.DriDefaults + ScriptOption.WithDependencies + ScriptOption.DriPrimaryKey + ScriptOption.DriNonClustered + ScriptOption.DriForeignKeys + ScriptOption.DriUniqueKeys + ScriptOption.SchemaQualify + ScriptOption.DriChecks

and so on.

DarshanSingh at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server SMO/DMO...

# 2

Sounds about right. Also ensure that PrimaryObject scritping option is selected.

The reason PrimaryObject exists is that is allows you to script Table Indexes without the table, etc.

MichielWories at 2007-9-9 >

# 3

Thanks for the answer.

I will try now

vbjunkie at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech