 |  |  |  |  |  |  |  |
Extract table statistics DDL
Please support our MS SQL advertiser: Intel Parallel Studio Home
 |
Hello everyone,
I searched extensively but was unable to find a solution to this problem. I'm attempting to generate the CREATE STATISTICS statement that was used to create an already existing statistics in an MSSQL db from its name or the table's name. I'm able to obtain the columns and the filter definition, but I cannot find anywhere that specifies the "FULLSCAN", "SAMPLE" and "STATS_STREAM" WITH options. I am querying the sys.stats and sys.stats_columns.
Please help me out with this! Thanks!
I searched extensively but was unable to find a solution to this problem. I'm attempting to generate the CREATE STATISTICS statement that was used to create an already existing statistics in an MSSQL db from its name or the table's name. I'm able to obtain the columns and the filter definition, but I cannot find anywhere that specifies the "FULLSCAN", "SAMPLE" and "STATS_STREAM" WITH options. I am querying the sys.stats and sys.stats_columns.
Please help me out with this! Thanks!
|
Similar Threads
- How to use trigger in C# (C#)
- HTML table parse problem (beautiful soup) (Python)
- Help in Acces Database (C#)
- Replacing truncate with partitions rotation (Oracle)
- the value of foreach loop keeps increasing (PHP)
- Need Some information. (MySQL)
- Compare Tables (VB.NET)
- PHP newbie, project feasibility (PHP)
Other Threads in the MS SQL Forum
- Previous Thread: SQL question releated to group by
- Next Thread: Help BCP The Following Query
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads
