SELECT SCHEMA_NAME(t.schema_id) AS schema_name, t.name AS table_nameFROM sys.tables AS tWHERE NOT EXISTS    (     SELECT * FROM sys.indexes AS i     WHERE i.object_id = t.object_id     AND i.type = 1  -- or type_desc = ‘CLUSTERED‘   )ORDER BY schema_name, table_name;GO

USE <database_name>;GOSELECT SCHEMA_NAME(schema_id) AS schema_name, name AS table_nameFROM sys.tables WHERE OBJECTPROPERTY(object_id,‘TableHasClustIndex‘) = 0ORDER BY schema_id, name;GO

USE <database_name>;GOSELECT ‘OBJECT‘ AS entity_type    ,USER_NAME(OBJECTPROPERTY(object_id, ‘OwnerId‘)) AS owner_name    ,name FROM sys.objects WHERE SCHEMA_NAME(schema_id) = ‘<schema_name>‘UNION SELECT ‘TYPE‘ AS entity_type    ,USER_NAME(TYPEPROPERTY(SCHEMA_NAME(schema_id) + ‘.‘ + name, ‘OwnerId‘)) AS owner_name    ,name FROM sys.types WHERE SCHEMA_NAME(schema_id) = ‘<schema_name>‘ UNIONSELECT ‘XML SCHEMA COLLECTION‘ AS entity_type     ,COALESCE(USER_NAME(xsc.principal_id),USER_NAME(s.principal_id)) AS owner_name    ,xsc.name FROM sys.xml_schema_collections AS xsc JOIN sys.schemas AS s    ON s.schema_id = xsc.schema_idWHERE s.name = ‘<schema_name>‘;GO

USE <database_name>;GOSELECT SCHEMA_NAME(t.schema_id) AS schema_name    ,t.name AS table_nameFROM sys.tables t WHERE object_id NOT IN    (    SELECT parent_object_id     FROM sys.key_constraints     WHERE type_desc = ‘PRIMARY_KEY_CONSTRAINT‘ -- or type = ‘PK‘    );GO

USE <database_name>;GOSELECT SCHEMA_NAME(schema_id) AS schema_name    ,name AS table_name FROM sys.tables WHERE OBJECTPROPERTY(object_id,‘TableHasPrimaryKey‘) = 0ORDER BY schema_name, table_name;GO

USE <database_name>;GOSELECT SCHEMA_NAME(schema_id) AS schema_name    ,name AS table_nameFROM sys.tables WHERE OBJECTPROPERTY(object_id,‘IsIndexed‘) = 0ORDER BY schema_name, table_name;GO

USE <database_name>;GOSELECT SCHEMA_NAME(schema_id) AS schema_name    , t.name AS table_name    , c.name AS column_nameFROM sys.tables AS tJOIN sys.identity_columns c ON t.object_id = c.object_idORDER BY schema_name, table_name;GO

USE <database_name>;GOSELECT SCHEMA_NAME(schema_id) AS schema_name    ,name AS table_name FROM sys.tables WHERE OBJECTPROPERTY(object_id,‘TableHasIdentity‘) = 1ORDER BY schema_name, table_name;GO

USE <database_name>;GOSELECT c.name AS column_name    ,c.column_id    ,SCHEMA_NAME(t.schema_id) AS type_schema    ,t.name AS type_name    ,t.is_user_defined    ,t.is_assembly_type    ,c.max_length    ,c.precision    ,c.scaleFROM sys.columns AS c JOIN sys.types AS t ON c.user_type_id=t.user_type_idWHERE c.object_id = OBJECT_ID(‘<schema_name.table_name>‘)ORDER BY c.column_id;GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id) AS referencing_object_name    ,COALESCE(COL_NAME(object_id, column_id), ‘(n/a)‘) AS referencing_column_name    ,*FROM sys.sql_dependenciesWHERE referenced_major_id = OBJECT_ID(‘<schema_name.function_name>‘)ORDER BY OBJECT_NAME(object_id), COL_NAME(object_id, column_id);GO 

USE <database_name>;GOSELECT name AS procedure_name     ,SCHEMA_NAME(schema_id) AS schema_name    ,type_desc    ,create_date    ,modify_dateFROM sys.procedures;GO

USE <database_name>;GOSELECT SCHEMA_NAME(schema_id) AS schema_name    ,o.name AS object_name    ,o.type_desc    ,p.parameter_id    ,p.name AS parameter_name    ,TYPE_NAME(p.user_type_id) AS parameter_type    ,p.max_length    ,p.precision    ,p.scale    ,p.is_outputFROM sys.objects AS oINNER JOIN sys.parameters AS p ON o.object_id = p.object_idWHERE o.object_id = OBJECT_ID(‘<schema_name.object_name>‘)ORDER BY schema_name, object_name, p.parameter_id;GO

USE <database_name>;GOSELECT name AS function_name   ,SCHEMA_NAME(schema_id) AS schema_name  ,type_desc  ,create_date  ,modify_dateFROM sys.objectsWHERE type_desc LIKE ‘%FUNCTION%‘;GO

USE <database_name>;GOSELECT name AS view_name   ,SCHEMA_NAME(schema_id) AS schema_name  ,OBJECTPROPERTYEX(object_id,‘IsIndexed‘) AS IsIndexed  ,OBJECTPROPERTYEX(object_id,‘IsIndexable‘) AS IsIndexable  ,create_date  ,modify_dateFROM sys.views;

USE <database_name>;GOSELECT name AS object_name   ,SCHEMA_NAME(schema_id) AS schema_name  ,type_desc  ,create_date  ,modify_dateFROM sys.objectsWHERE modify_date > GETDATE() - <n_days>ORDER BY modify_date;GO

 USE <database_name>;GOSELECT name AS column_name     ,column_id     ,TYPE_NAME(user_type_id) AS type_name    ,max_length    ,CASE        WHEN max_length = -1 AND TYPE_NAME(user_type_id) <> ‘xml‘            THEN 1            ELSE 0     END AS [(max)]FROM sys.columnsWHERE object_id=OBJECT_ID(‘<schema_name.table_name>‘)     AND ( TYPE_NAME(user_type_id) IN (‘xml‘,‘text‘, ‘ntext‘,‘image‘)         OR (TYPE_NAME(user_type_id) IN (‘varchar‘,‘nvarchar‘,‘varbinary‘)         AND max_length = -1)        );GO

USE <database_name>;GOSELECT definitionFROM sys.sql_modulesWHERE object_id = OBJECT_ID(‘<schema_name.object_name>‘);GO

USE <database_name>;GOSELECT OBJECT_DEFINITION (OBJECT_ID(‘<schema_name.object_name>‘)) AS ObjectDefinition;GO

SELECT definitionFROM sys.server_sql_modules;GO

USE <database_name>;GOSELECT i.name AS index_name    ,ic.index_column_id    ,key_ordinal    ,c.name AS column_name    ,TYPE_NAME(c.user_type_id)AS column_type     ,is_identityFROM sys.indexes AS iINNER JOIN sys.index_columns AS ic     ON i.object_id = ic.object_id AND i.index_id = ic.index_idINNER JOIN sys.columns AS c     ON ic.object_id = c.object_id AND c.column_id = ic.column_idWHERE i.is_primary_key = 1     AND i.object_id = OBJECT_ID(‘<schema_name.table_name>‘);GO

USE <database_name>;GOSELECT i.name AS index_name    ,COL_NAME(ic.object_id,ic.column_id) AS column_name    ,ic.index_column_id    ,key_ordinalFROM sys.indexes AS iINNER JOIN sys.index_columns AS ic     ON i.object_id = ic.object_id AND i.index_id = ic.index_idWHERE i.is_primary_key = 1     AND i.object_id = OBJECT_ID(‘<schema_name.table_name>‘);GO

USE <database_name>;GOSELECT     f.name AS foreign_key_name   ,OBJECT_NAME(f.parent_object_id) AS table_name   ,COL_NAME(fc.parent_object_id, fc.parent_column_id) AS constraint_column_name   ,OBJECT_NAME (f.referenced_object_id) AS referenced_object   ,COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS referenced_column_name   ,is_disabled   ,delete_referential_action_desc   ,update_referential_action_descFROM sys.foreign_keys AS fINNER JOIN sys.foreign_key_columns AS fc    ON f.object_id = fc.constraint_object_id WHERE f.parent_object_id = OBJECT_ID(‘<schema_name.table_name>‘);

-- Create a function to return the name of the entity on which the permissions are checked.IF OBJECT_ID (N‘dbo.entity_instance_name‘, N‘FN‘) IS NOT NULL    DROP FUNCTION dbo.entity_instance_name;GOCREATE FUNCTION dbo.entity_instance_name(@class_desc nvarchar(60), @major_id int) RETURNS sysname ASBEGIN    DECLARE @the_entity_name sysname    SELECT @the_entity_name = CASE        WHEN @class_desc = ‘DATABASE‘ THEN DB_NAME()        WHEN @class_desc = ‘SCHEMA‘ THEN SCHEMA_NAME(@major_id)        WHEN @class_desc = ‘OBJECT_OR_COLUMN‘ THEN OBJECT_NAME(@major_id)        WHEN @class_desc = ‘DATABASE_PRINCIPAL‘ THEN USER_NAME(@major_id)        WHEN @class_desc = ‘ASSEMBLY‘ THEN             (SELECT name FROM sys.assemblies WHERE assembly_id=@major_id)        WHEN @class_desc = ‘TYPE‘ THEN TYPE_NAME(@major_id)        WHEN @class_desc = ‘XML_SCHEMA_COLLECTION‘ THEN             (SELECT name FROM sys.xml_schema_collections              WHERE xml_collection_id=@major_id)        WHEN @class_desc = ‘MESSAGE_TYPE‘ THEN             (SELECT name FROM sys.service_message_types WHERE message_type_id=@major_id)        WHEN @class_desc = ‘SERVICE_CONTRACT‘ THEN            (SELECT name FROM sys.service_contracts              WHERE service_contract_id=@major_id)        WHEN @class_desc = ‘SERVICE‘ THEN          (SELECT name FROM sys.services WHERE service_id=@major_id)        WHEN @class_desc = ‘REMOTE_SERVICE_BINDING‘ THEN          (SELECT name FROM sys.remote_service_bindings             WHERE remote_service_binding_id=@major_id)        WHEN @class_desc = ‘ROUTE‘ THEN          (SELECT name FROM sys.routes WHERE route_id=@major_id)        WHEN @class_desc = ‘FULLTEXT_CATALOG‘ THEN          (SELECT name FROM sys.fulltext_catalogs WHERE fulltext_catalog_id=@major_id)        WHEN @class_desc = ‘SYMMETRIC_KEY‘ THEN          (SELECT name FROM sys.symmetric_keys WHERE symmetric_key_id=@major_id)        WHEN @class_desc = ‘CERTIFICATE‘ THEN          (SELECT name FROM sys.certificates WHERE certificate_id=@major_id)        WHEN @class_desc = ‘ASYMMETRIC_KEY‘ THEN          (SELECT name FROM sys.asymmetric_keys WHERE asymmetric_key_id=@major_id)        WHEN @class_desc = ‘SERVER‘ THEN              (SELECT name FROM sys.servers WHERE server_id=@major_id)        WHEN @class_desc = ‘SERVER_PRINCIPAL‘ THEN SUSER_NAME(@major_id)        WHEN @class_desc = ‘ENDPOINT‘ THEN              (SELECT name FROM sys.endpoints WHERE endpoint_id=@major_id)              ELSE ‘?‘    END    RETURN @the_entity_nameEND;GO-- Return server-level permissions for the user.SELECT class    ,class_desc    ,dbo.entity_instance_name(class_desc, major_id) AS entity_name     ,minor_id    ,SUSER_NAME(grantee_principal_id) AS grantee    ,SUSER_NAME(grantor_principal_id) AS grantor    ,type    ,permission_name    ,state_desc FROM sys.server_permissions WHERE grantee_principal_id = SUSER_ID(‘public‘);GO-- Return database-level permissions for the user.SELECT class    ,class_desc    ,dbo.entity_instance_name(class_desc , major_id) AS entity_name     ,minor_id    ,USER_NAME(grantee_principal_id) AS grantee    ,USER_NAME(grantor_principal_id) AS grantor    ,type    ,permission_name    ,state_desc   FROM  sys.database_permissions WHERE grantee_principal_id = DATABASE_PRINCIPAL_ID(‘public‘);GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id) AS object_name    ,COL_NAME(object_id, column_id) AS computed_column     ,class_desc    ,is_selected    ,is_updated    ,is_select_allFROM sys.sql_dependenciesWHERE referenced_major_id = OBJECT_ID(‘<schema_name.table_name>‘)    AND referenced_minor_id = COLUMNPROPERTY(referenced_major_id, ‘<column_name>‘, ‘ColumnId‘)    AND class = 1;GO

USE <database_name>;GOSELECT OBJECT_NAME(d.referenced_major_id) AS object_name    ,COL_NAME(d.referenced_major_id, d.referenced_minor_id) AS column_name    ,OBJECT_NAME(referenced_major_id) AS dependent_object_name     ,COL_NAME(d.object_id, d.column_id) AS dependent_computed_column    ,cc.definition AS computed_column_definitionFROM sys.sql_dependencies AS dJOIN sys.computed_columns AS cc     ON cc.object_id = d.object_id AND cc.column_id = d.column_id AND d.object_id=d.referenced_major_id     WHERE d.class = 1ORDER BY object_name, column_name;GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id) AS object_name     ,c.name AS column_name     ,SCHEMA_NAME(t.schema_id) AS schema_name    ,TYPE_NAME(c.user_type_id) AS user_type_name    ,c.max_length    ,c.precision    ,c.scale    ,c.is_nullable    ,c.is_computedFROM sys.columns AS cINNER JOIN sys.types AS t ON c.user_type_id = t.user_type_idWHERE c.user_type_id = TYPE_ID(‘<schema_name.data_type_name>‘); GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id) AS object_name     ,COL_NAME(object_id, column_id) AS column_name    ,TYPE_NAME(user_type_id) AS user_typeFROM sys.column_type_usagesWHERE user_type_id = TYPE_ID(‘<schema_name.data_type_name>‘);GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id) AS object_name    ,COL_NAME(object_id, column_id) AS column_nameFROM sys.sql_dependenciesWHERE referenced_major_id = TYPE_ID(‘<schema_name.data_type_name>‘)    AND class = 2 -- schema-bound references to type    AND OBJECTPROPERTY(object_id, ‘IsTable‘) = 1;   -- exclude non-table dependencies 

USE <database_name>;GOSELECT OBJECT_NAME(object_id) AS object_name    ,NULL AS procedure_number    ,name AS param_name    ,parameter_id AS param_num    ,TYPE_NAME(p.user_TYPE_ID) AS type_nameFROM sys.parameters AS pWHERE p.user_TYPE_ID = TYPE_ID(‘<schema_name.data_type_name>‘)UNION SELECT OBJECT_NAME(object_id) AS object_name    ,procedure_number    ,name AS param_name    ,parameter_id AS param_num    ,TYPE_NAME(p.user_TYPE_ID) AS type_nameFROM sys.numbered_procedure_parameters AS pWHERE p.user_TYPE_ID = TYPE_ID(‘<schema_name.data_type_name>‘)ORDER BY object_name, procedure_number, param_num;GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id) AS object_name    ,parameter_id    ,TYPE_NAME(user_type_id) AS type_nameFROM sys.parameter_type_usages WHERE user_type_id = TYPE_ID(‘<schema_name.data_type_name>‘);GO

USE <database_name>;GOSELECT SCHEMA_NAME(o.schema_id) AS schema_name    ,OBJECT_NAME(o.parent_object_id) AS table_name    ,OBJECT_NAME(o.object_id) AS constraint_nameFROM sys.sql_dependencies AS dJOIN sys.objects AS o ON o.object_id = d.object_idWHERE referenced_major_id = TYPE_ID(‘<schema_name.data_type_name>‘)    AND class = 2 -- schema-bound references to type    AND OBJECTPROPERTY(o.object_id, ‘IsCheckCnst‘) = 1; -- exclude non-CHECK dependenciesGO

USE <database_name>;GOSELECT SCHEMA_NAME(o.schema_id) AS dependent_object_schema  ,OBJECT_NAME(o.object_id) AS dependent_object_name  ,o.type_desc AS dependent_object_type  ,d.class_desc AS kind_of_dependency  ,TYPE_NAME (d.referenced_major_id) AS type_nameFROM sys.sql_dependencies AS d JOIN sys.objects AS o  ON d.object_id = o.object_id  AND o.type IN (‘FN‘,‘IF‘,‘TF‘, ‘V‘, ‘P‘)WHERE d.class = 2 -- dependencies on types  AND d.referenced_major_id = TYPE_ID(‘<schema_name.data_type_name>‘)ORDER BY dependent_object_schema, dependent_object_name;GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id) as constraint_name    ,SCHEMA_NAME(schema_id) AS schema_name    ,OBJECT_NAME(parent_object_id) AS table_name    ,type_desc    ,create_date    ,modify_date    ,is_ms_shipped    ,is_published    ,is_schema_publishedFROM sys.objectsWHERE type_desc LIKE ‘%CONSTRAINT‘     AND parent_object_id = OBJECT_ID(‘<schema_name.table_name>‘);GO

USE <database_name>;GOSELECT i.name AS index_name    ,i.type_desc    ,is_unique    ,ds.type_desc AS filegroup_or_partition_scheme    ,ds.name AS filegroup_or_partition_scheme_name    ,ignore_dup_key    ,is_primary_key    ,is_unique_constraint    ,fill_factor    ,is_padded    ,is_disabled    ,allow_row_locks    ,allow_page_locksFROM sys.indexes AS iINNER JOIN sys.data_spaces AS ds ON i.data_space_id = ds.data_space_idWHERE is_hypothetical = 0 AND i.index_id <> 0 AND i.object_id = OBJECT_ID(‘<schema_name.table_name>‘);GO

USE <database_name>;GOSELECT OBJECT_NAME(object_id)FROM sys.columnsWHERE name = ‘<column_name>‘;GO

USE <database_name>;GOSELECT SCHEMA_NAME(o.schema_id) AS schema_name     ,o.name AS object_name    ,type_descFROM sys.objects AS oINNER JOIN sys.columns AS c ON o.object_id = c.object_idWHERE c.name = ‘<column_name>‘;GO

USE <database_name>;GOSELECT * FROM sys.tables;GO

USE <database_name>;GOSELECT SCHEMA_NAME(o.schema_id) AS schema_name    ,OBJECT_NAME(p.object_id) AS table_name    ,i.name AS index_name    ,p.partition_number    ,rows FROM sys.partitions AS pINNER JOIN sys.indexes AS i ON p.object_id = i.object_id AND p.index_id = i.index_idINNER JOIN sys.partition_schemes ps ON i.data_space_id=ps.data_space_idINNER JOIN sys.objects AS o ON o.object_id = i.object_idORDER BY index_name, partition_number;GO

USE <database_name>;GOSELECT name AS statistics_name    ,stats_id    ,auto_created    ,user_created    ,no_recomputeFROM sys.statsWHERE object_id = OBJECT_ID(‘<schema_name.object_name>‘);GO

USE <database_name>;GOSELECT s.name AS statistics_name    ,c.name AS column_name    ,sc.stats_column_idFROM sys.stats AS sINNER JOIN sys.stats_columns AS sc     ON s.object_id = sc.object_id AND s.stats_id = sc.stats_idINNER JOIN sys.columns AS c     ON sc.object_id = c.object_id AND c.column_id = sc.column_idWHERE s.object_id = OBJECT_ID(‘<schema_name.object_name>‘);GO

USE <database_name>;GOSELECT definitionFROM sys.sql_modulesWHERE object_id = OBJECT_ID(‘<schema_name.object_name>‘);GO

USE <database_name>;GOSELECT OBJECT_DEFINITION (OBJECT_ID(‘<schema_name.object_name>‘)) AS ObjectDefinition;GO