list of partitioned table in SQL Server

select distinct t.name
from sys.partitions p
inner join sys.tables t
on p.object_id = t.object_id
where p.partition_number <> 1


Key Words : SQL Server 2012

Comments

Post a Comment

Popular posts from this blog

c# Json Pretiffy

public   static   string  JsonPrettify( string  json) {      using  ( var  stringReader =  new   StringReader (json))      using  ( var  stringWriter =  new   StringWriter ())     {          var  jsonReader =  new   JsonTextReader (stringReader);          var  jsonWriter =  new   JsonTextWriter (stringWriter) { Formatting =  Formatting .Indented };         jsonWriter.WriteToken(jsonReader);          return  stringWriter.ToString();     } }
Read more

List of column in SQL Server Tables

SELECT   SchemaName = c.table_schema,          TableName = c.table_name,          ColumnName = c.column_name,          DataType = data_type FROM     information_schema.columns c          INNER JOIN information_schema.tables t            ON c.table_name = t.table_name               AND c.table_schema = t.table_schema               AND t.table_type = 'BASE TABLE' ORDER BY SchemaName,          TableName,          ordinal_position
Read more