This procedure was created to automate the dropping of statistics on a user specified table.
Very simple code, but handy if the need is there.
Replace 'tablename' throughout script with the name of the table intended to temporarily house the statistics name(s).
Stored Proc to List Columns for a Primary Key
Stored procedure to return the list of columns of the primary key for a table. The name of the column for the result set is the name of the primary key for the table.
2006-09-14 (first published: 2006-09-07)
689 reads