Sql Server Table Analysis
SELECT C.name 'COLUMNNAME',T.name 'TABLENAME' FROM SYS.[columns] c JOIN SYS.tables t ON C.[object_id]=T.[object_id] WHERE T.NAME LIKE '%service%' or C.NAME LIKE '%service%' ORDER BY ColumnName, TableName
/ *Details View*/ SELECT DISTINCT TABLE_CATALOG , TABLE_SCHEMA , TABLE_NAME , COLUMN_NAME , ORDINAL_POSITION , DATA_TYPE , IS_NULLABLE , CHARACTER_MAXIMUM_LENGTH -- SELECT TOP 1000 * FROM INFORMATION_SCHEMA.COLUMNS --WHERE TABLE_NAME = 'risk_scores' WHERE COLUMN_NAME LIKE '%Service%' ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME /*Details of All Procedures*/ select procedures.object_id ,procedures.[name] as [SP Name],parameters.name [Parameter] from sys.parameters inner join sys.procedures on parameters.object_id = procedures.object_id inner join sys.types on parameters.system_type_id = types.system_type_id AND parameters.user_type_id = types.user_type_id where procedures.name IN (select distinct name from sys.objects where type = 'P' )
SELECT T.name 'TABLE NAME',C.name 'COLUMN NAME' FROM SYS.[columns] c JOIN SYS.tables t ON C.[object_id]=T.[object_id] WHERE C.NAME LIKE '%POD%'
/* Script for SelectTopNRows command from SSMS* / Sp_help DimRevenue Sp_Depends DimRevenue Select * from Sys.tables where name='DimRevenue'