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
How Can i script the contents of table ?
Hot Topic
- Loooonnngggg delay in loading due to "pre-validation". Can it be turned OFF?
- Problems with Date And Time
- How to set empty a space from a derived column expression?
- sp_dboption
- Transferring data from a Smartware database to SQL Server 2005 using SSIS?
- Puzzled by concurrent update
- SQL SERVER 2005 DATABASE MIRRORING for large number of databases
- Business Intelligence Project?
- Bug?-when using nested subreports in combination with list
- Loading Large .dtsx Files in BIDS
SQL Server
- Create DBF file from ADO.Net
- RS report window
- create user only with permissions, to select, insert, update, delete, and exec sps
- linked server exec stored procdure results in Transaction context in use by another session.
- Calling child package out of process fails with Access Denied.
- Uninstall Reporting Services
- how to access a cube and its dimensions in a cube
- SqlCePeplication.Synchronize
- Best material on MDX scripts?
- dataflow and expressions
How Can i script the contents of table ?
-M-
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.
Joku
I will try now
nemesisv
The reason PrimaryObject exists is that is allows you to script Table Indexes without the table, etc.