Segoe UI0SQLData Source=kretalocal;Initial Catalog=Kreta_HetSulitrueIntegrateda1b52e66-7c8a-4712-89b8-2220fbf8bc7akretalocal=Parameters!ObjectName.ValueSELECT
t.[name] AS TableName
,c.column_id AS ColumnOrder
,c.[name] AS ColumnName
,ty.name
,ty.[name] +
CASE
WHEN c.max_length = -1 THEN '(max)'
WHEN ty.[name] IN ('nvarchar', 'nchar', 'ntext') THEN '(' + CAST(c.max_length / 2 AS varchar(10)) + ')'
WHEN ty.[name] IN ('varchar', 'char', 'text') THEN '(' + CAST(c.max_length AS varchar(10)) + ')'
WHEN ty.[name] = 'numeric' THEN '(' + CAST(c.[precision] AS varchar(10)) + ', ' + CAST(c.scale AS varchar(10)) + ')'
ELSE ''
END AS DataType
,IIF(c.is_nullable = 1, 'Yes', 'No') AS IsNullable
,df.definition AS DefaultValue
,ep.[value] AS Description
,fk1.ForeignKey
,fk1.ReferencedObject
FROM sys.tables t
INNER JOIN sys.columns c on t.object_id = c.object_id
LEFT JOIN sys.extended_properties ep on ep.major_id = c.object_id AND ep.minor_id = c.column_id AND ep.name = 'MS_Description'
INNER JOIN sys.types ty ON ty.user_type_id = c.user_type_id
LEFT JOIN sys.default_constraints df ON df.object_id = c.default_object_id
OUTER APPLY (
SELECT TOP(1) fk.name AS ForeignKey, rt.name + '.' + rc.name AS ReferencedObject --fk.parent_object_id, fkc.parent_column_id, fk.name AS ForeignKey, rt.name AS ReferencedTable, rc.name AS ReferencedColumn
FROM sys.foreign_keys fk
INNER JOIN sys.foreign_key_columns fkc ON fkc.constraint_object_id = fk.object_id
INNER JOIN sys.tables rt ON fkc.referenced_object_id = rt.object_id
INNER JOIN sys.columns rc ON rc.column_id = fkc.referenced_column_id AND rc.object_id = rt.object_id
WHERE fkc.parent_object_id = t.object_id AND fkc.parent_column_id = c.column_id
AND rc.name IN ('ID', 'Azonosito')
) fk1
WHERE t.object_id = OBJECT_ID(@ObjectName)trueTableNameSystem.StringColumnOrderSystem.Int32ColumnNameSystem.StringnameSystem.StringDataTypeSystem.StringIsNullableSystem.StringDefaultValueSystem.StringDescriptionSystem.ObjectForeignKeySystem.StringReferencedObjectSystem.Stringkretalocal=Parameters!ObjectName.ValueSELECT
i.name AS Name
,i.type_desc AS Type
,IIF(i.is_unique = 1, 'UK', NULL) AS UniqueIndex
,IIF(i.is_primary_key = 1, 'PK', NULL) AS PrimaryKey
,i.filter_definition AS Filter
,STUFF((
SELECT char(10) + c.name
FROM sys.index_columns ic
INNER JOIN sys.columns c on ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE ic.object_id = i.object_id AND i.index_id = ic.index_id AND ic.is_included_column = 0
FOR XML PATH('')),1,1,'') AS Columns
,STUFF((
SELECT char(10) + c.name
FROM sys.index_columns ic
INNER JOIN sys.columns c on ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE ic.object_id = i.object_id AND i.index_id = ic.index_id AND ic.is_included_column = 1
FOR XML PATH('')),1,1,'') AS IncludedColumns
FROM sys.indexes i
WHERE i.object_id = OBJECT_ID(@ObjectName)NameSystem.StringTypeSystem.StringUniqueIndexSystem.StringPrimaryKeySystem.StringFilterSystem.StringColumnsSystem.StringIncludedColumnsSystem.Stringkretalocal=Parameters!ObjectName.ValueSELECT
DENSE_RANK() OVER(ORDER BY fk.name) AS DenseRank
,fk.name AS ForeignKeyName
,fkc.constraint_column_id ColumnOrder
,c.name AS ColumnName
,rt.name AS ReferencedTable
,rc.name AS ReferencedColumn --fk.parent_object_id, fkc.parent_column_id, fk.name AS ForeignKey, rt.name AS ReferencedTable, rc.name AS ReferencedColumn
FROM sys.foreign_keys fk
INNER JOIN sys.foreign_key_columns fkc ON fkc.constraint_object_id = fk.object_id
INNER JOIN sys.tables rt ON fkc.referenced_object_id = rt.object_id
INNER JOIN sys.columns rc ON rc.column_id = fkc.referenced_column_id AND rc.object_id = rt.object_id
INNER JOIN sys.columns c ON c.column_id = fkc.parent_column_id AND c.object_id = fk.parent_object_id
WHERE fkc.parent_object_id = OBJECT_ID(@ObjectName)
ORDER BY fk.nameDenseRankSystem.Int64ForeignKeyNameSystem.StringColumnOrderSystem.Int32ColumnNameSystem.StringReferencedTableSystem.StringReferencedColumnSystem.Stringkretalocal=Parameters!ObjectName.ValueSELECT
t.[name] AS TableName
,ep.[value] AS Description
FROM sys.tables t
LEFT JOIN sys.extended_properties ep on ep.major_id = t.object_id AND ep.minor_id = 0 AND ep.name = 'MS_Description'
WHERE t.object_id = OBJECT_ID(@ObjectName) TableNameSystem.StringDescriptionSystem.Objectkretalocal=Parameters!ObjectName.ValueSELECT
DENSE_RANK() OVER(ORDER BY fk.name) AS DenseRank
,fk.name AS ForeignKeyName
,fkc.constraint_column_id ColumnOrder
,c.name AS ColumnName
,rt.name AS ReferencingTable
,rc.name AS ReferencingColumn --fk.parent_object_id, fkc.parent_column_id, fk.name AS ForeignKey, rt.name AS ReferencedTable, rc.name AS ReferencedColumn
,fkc.*
FROM sys.foreign_keys fk
INNER JOIN sys.foreign_key_columns fkc ON fkc.constraint_object_id = fk.object_id
INNER JOIN sys.tables rt ON fkc.parent_object_id = rt.object_id
INNER JOIN sys.columns rc ON rc.column_id = fkc.parent_column_id AND rc.object_id = rt.object_id
INNER JOIN sys.columns c ON c.column_id = fkc.referenced_column_id AND c.object_id = fkc.referenced_object_id
WHERE fkc.referenced_object_id = OBJECT_ID(@ObjectName)
ORDER BY fk.name, fkc.constraint_column_idDenseRankSystem.Int64ForeignKeyNameSystem.StringColumnOrderSystem.Int32ColumnNameSystem.StringReferencingTableSystem.StringReferencingColumnSystem.Stringconstraint_object_idSystem.Int32constraint_column_idSystem.Int32parent_object_idSystem.Int32parent_column_idSystem.Int32referenced_object_idSystem.Int32referenced_column_idSystem.Int320.8205cm6.3771cm2.5cm2.2751cm2.42125cm12.5926cm5.95312cm0.75406cmtrue=Fields!ColumnOrder.ValuetrueTextbox3#3857652pt2pt2pt2pttrue=Fields!ColumnName.ValuetrueColumn NameTextbox5#3857652pt2pt2pt2pttrue=Fields!DataType.ValuetrueData TypeTextbox41#3857652pt2pt2pt2pttrue=Fields!IsNullable.ValuetrueNullableTextbox11#3857652pt2pt2pt2pttrue=Fields!DefaultValue.ValuetrueDefaultTextbox13#3857652pt2pt2pt2pttrue=Fields!Description.ValuetrueDescriptionTextbox15#3857652pt2pt2pt2pttrue=Fields!ReferencedObject.ValuetrueReferenced ObjectTextbox19#3857652pt2pt2pt2pt0.62177cmtruetrue=Fields!ColumnOrder.ValueColumnOrder=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ColumnName.ValueColumnName=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!DataType.ValueDataType=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!IsNullable.ValueIsNullable=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!DefaultValue.ValueDefaultValue=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!Description.ValueDescription=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ReferencedObject.ValueReferencedObject=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2ptAfterColumnList=Fields!TableName.Value=Fields!ColumnOrder.Value4.72432cm0.36724cm1.37583cm32.93967cmtruetrue=First(Fields!TableName.Value, "TableProperty")Textbox210.73766cm0.36724cm1.02333cm18.82479cm12pt2pt2pt2pttruetrue=First(Fields!Description.Value, "TableProperty")Textbox221.9021cm0.36725cm1.5525cm31.62937cm22pt2pt2pt2pt0.7147cm9.49823cm2.92333cm0.88698cm0.96542cm6.01896cm6.49552cm5.03968cm0.65292cmtruetrue#Textbox2#3857652pt2pt2pt2pttruetrueNameTextbox23#3857652pt2pt2pt2pttruetrueTypeTextbox25#3857652pt2pt2pt2pt3truetrueColumnsTextbox37#3857652pt2pt2pt2pttruetrueIncluded ColumnsTextbox39#3857652pt2pt2pt2pttruetrueFilterTextbox31#3857652pt2pt2pt2pt0.6cmtruetrue=RowNumber(NOTHING)Textbox9=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!Name.ValueName=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!Type.ValueType=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!UniqueIndex.ValueUniqueIndex=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!PrimaryKey.ValuePrimaryKey=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!Columns.ValueColumns1=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!IncludedColumns.ValueIncludedColumns1=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!Filter.ValueFilter=IIF(ROWNUMBER(NOTHING) MOD 2, "#e5e9ec", "White")2pt2pt2pt2ptAfterIndexList11.83542cm0.36724cm1.25292cm32.54282cm3truetrueColumnsTextbox224.12432cm0.36724cm0.6cm18.82479cm42pt2pt2pt2pttruetrueIndexesTextbox2211.16486cm0.36724cm0.6cm18.82479cm52pt2pt2pt2pttruetrueRHTMLeferences toTextbox226.38071cm0.36724cm0.6cm18.82479cm62pt2pt2pt2pt0.71469cm5.46365cm5.50332cm6.48198cm7.51262cm0.6572cmtruetrue#Textbox3#3857652pt2pt2pt2pttruetrueForeign Key NameTextbox5#3857652pt2pt2pt2pttruetrueColumn NameTextbox41#3857652pt2pt2pt2pttruetrueReferenced TableTextbox11#3857652pt2pt2pt2pttruetrueReferenced ColumnTextbox13#3857652pt2pt2pt2pt0.62177cmtruetrue=IIf(Fields!ColumnOrder.Value = 1,Fields!DenseRank.Value, "")ColumnOrder=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=IIf(Fields!ColumnOrder.Value = 1,Fields!ForeignKeyName.Value, "")ColumnName=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ColumnName.ValueDataType=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ReferencedTable.ValueIsNullable=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ReferencedColumn.ValueDefaultValue=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2ptAfterForeignKeys=Fields!DenseRank.Value=Fields!ColumnOrder.Value7.05127cm0.36724cm1.27897cm25.67626cm7truetrueReferenced byTextbox228.67833cm0.36724cm0.6cm18.82479cm82pt2pt2pt2pt0.71469cm5.46365cm5.50331cm6.48198cm7.51262cm0.64823cmtruetrue#Textbox3#3857652pt2pt2pt2pttruetrueForeign Key NameTextbox5#3857652pt2pt2pt2pttruetrueColumn NameTextbox41#3857652pt2pt2pt2pttruetrueReferencing TableTextbox11#3857652pt2pt2pt2pttruetrueReferencing ColumnTextbox13#3857652pt2pt2pt2pt0.62177cmtruetrue=IIf(Fields!ColumnOrder.Value = 1, Fields!DenseRank.Value, "")ColumnOrder=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=IIf(Fields!ColumnOrder.Value = 1, Fields!ForeignKeyName.Value, "")ColumnName=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ColumnName.ValueDataType=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ReferencingTable.ValueIsNullable=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2pttruetrue=Fields!ReferencingColumn.ValueDefaultValue=IIF(Fields!DenseRank.Value MOD 2, "#e5e9ec", "White")2pt2pt2pt2ptAfterForeignKey2=Fields!DenseRank.Value=Fields!ColumnOrder.Value9.34889cm0.36725cm1.27cm25.67625cm9truetrueGenerated at =Format(Now(), "yyyy.MM.dd. HH.mm")Textbox2213.5599cm0.36724cm0.67938cm31.62937cm102pt2pt2pt2pt14.92719cm34.49661cm29.7cm21cm0cm21cm2cm2cm2cm2cm0.13cmStringObject Name4100ObjectNameCm1f609c4a-50f5-4898-bacb-ebeec194a20e