Schema: [AdventureWorks2016CTP3].[dbo].[SQLCop]

CollapseAll image

Collapse image Schema properties


 Name   Value 
 Name   [SQLCop] 
 Owner   [dbo] 
 ID   13 

Collapse image Objects


Name Type
[SQLCop].[test] Procedure
[SQLCop].[test Ad hoc distributed queries] Procedure
[SQLCop].[test Agent Service] Procedure
[SQLCop].[test Auto close] Procedure
[SQLCop].[test Auto create statistics] Procedure
[SQLCop].[test Auto Shrink] Procedure
[SQLCop].[test Auto update statistics] Procedure
[SQLCop].[test Buffer cache hit ratio] Procedure
[SQLCop].[test Column collation does not match database default] Procedure
[SQLCop].[test Column data types (Numeric vs. Int)] Procedure
[SQLCop].[test Column Name Problems] Procedure
[SQLCop].[test Columns of data type Text/nText] Procedure
[SQLCop].[test Columns with float data type] Procedure
[SQLCop].[test Columns with image data type] Procedure
[SQLCop].[test Compatibility Level] Procedure
[SQLCop].[test Database and Log files on the same disk] Procedure
[SQLCop].[test Database collation] Procedure
[SQLCop].[test Database Mail] Procedure
[SQLCop].[test Decimal Size Problem] Procedure
[SQLCop].[test Forwarded Records] Procedure
[SQLCop].[test Fragmented Indexes] Procedure
[SQLCop].[test Instant File Initialization] Procedure
[SQLCop].[test Login Language] Procedure
[SQLCop].[test Max degree of parallelism] Procedure
[SQLCop].[test Missing Foreign Key Indexes] Procedure
[SQLCop].[test Missing Foreign Keys] Procedure
[SQLCop].[test Old Backups] Procedure
[SQLCop].[test Ole Automation Procedures] Procedure
[SQLCop].[test Orphaned Users] Procedure
[SQLCop].[test Page life expectancy] Procedure
[SQLCop].[test Procedures Named SP_] Procedure
[SQLCop].[test Procedures that call undocumented procedures] Procedure
[SQLCop].[test Procedures using dynamic SQL without sp_executesql] Procedure
[SQLCop].[test Procedures with @@Identity] Procedure
[SQLCop].[test Procedures With SET ROWCOUNT] Procedure
[SQLCop].[test Procedures without SET NOCOUNT ON] Procedure
[SQLCop].[test Service Account] Procedure
[SQLCop].[test SMO and DMO] Procedure
[SQLCop].[test Table name problems] Procedure
[SQLCop].[test Tables that start with tbl] Procedure
[SQLCop].[test Tables without a primary key] Procedure
[SQLCop].[test Tables without any data] Procedure
[SQLCop].[test UniqueIdentifier with NewId] Procedure
[SQLCop].[test Unnamed Constraints] Procedure
[SQLCop].[test User Aliases] Procedure
[SQLCop].[test Varchar Size Problem] Procedure
[SQLCop].[test Views with order by] Procedure
[SQLCop].[test Wide Table] Procedure
[SQLCop].[test xp_cmdshell is enabled] Procedure
Total: 49 object(s)

Collapse image Objects that depend on [SQLCop]


Object name Object type Dep level
[SQLCop].[test] Procedure 1
[SQLCop].[test Ad hoc distributed queries] Procedure 1
[SQLCop].[test Agent Service] Procedure 1
[SQLCop].[test Auto close] Procedure 1
[SQLCop].[test Auto create statistics] Procedure 1
[SQLCop].[test Auto Shrink] Procedure 1
[SQLCop].[test Auto update statistics] Procedure 1
[SQLCop].[test Buffer cache hit ratio] Procedure 1
[SQLCop].[test Column collation does not match database default] Procedure 1
[SQLCop].[test Column data types (Numeric vs. Int)] Procedure 1
[SQLCop].[test Column Name Problems] Procedure 1
[SQLCop].[test Columns of data type Text/nText] Procedure 1
[SQLCop].[test Columns with float data type] Procedure 1
[SQLCop].[test Columns with image data type] Procedure 1
[SQLCop].[test Compatibility Level] Procedure 1
[SQLCop].[test Database and Log files on the same disk] Procedure 1
[SQLCop].[test Database collation] Procedure 1
[SQLCop].[test Database Mail] Procedure 1
[SQLCop].[test Decimal Size Problem] Procedure 1
[SQLCop].[test Forwarded Records] Procedure 1
[SQLCop].[test Fragmented Indexes] Procedure 1
[SQLCop].[test Instant File Initialization] Procedure 1
[SQLCop].[test Login Language] Procedure 1
[SQLCop].[test Max degree of parallelism] Procedure 1
[SQLCop].[test Missing Foreign Key Indexes] Procedure 1
[SQLCop].[test Missing Foreign Keys] Procedure 1
[SQLCop].[test Old Backups] Procedure 1
[SQLCop].[test Ole Automation Procedures] Procedure 1
[SQLCop].[test Orphaned Users] Procedure 1
[SQLCop].[test Page life expectancy] Procedure 1
[SQLCop].[test Procedures Named SP_] Procedure 1
[SQLCop].[test Procedures that call undocumented procedures] Procedure 1
[SQLCop].[test Procedures using dynamic SQL without sp_executesql] Procedure 1
[SQLCop].[test Procedures with @@Identity] Procedure 1
[SQLCop].[test Procedures With SET ROWCOUNT] Procedure 1
[SQLCop].[test Procedures without SET NOCOUNT ON] Procedure 1
[SQLCop].[test Service Account] Procedure 1
[SQLCop].[test SMO and DMO] Procedure 1
[SQLCop].[test Table name problems] Procedure 1
[SQLCop].[test Tables that start with tbl] Procedure 1
[SQLCop].[test Tables without a primary key] Procedure 1
[SQLCop].[test Tables without any data] Procedure 1
[SQLCop].[test UniqueIdentifier with NewId] Procedure 1
[SQLCop].[test Unnamed Constraints] Procedure 1
[SQLCop].[test User Aliases] Procedure 1
[SQLCop].[test Varchar Size Problem] Procedure 1
[SQLCop].[test Views with order by] Procedure 1
[SQLCop].[test Wide Table] Procedure 1
[SQLCop].[test xp_cmdshell is enabled] Procedure 1
Total 49 object(s)

Collapse image Extended properties


Name  Value 
tSQLt.TestClass 1

Collapse image SQL


CREATE SCHEMA [SQLCop]
    AUTHORIZATION [dbo]
GO
EXEC sp_addextendedproperty N'tSQLt.TestClass', 1, 'SCHEMA', N'SQLCop', NULL, NULL, NULL, NULL
GO

Collapse image See also


List of schemas