# SQL Server Rule: SRD0039
| | |
|----|----|
| Assembly | SqlServer.Rules |
| Namespace | SqlServer.Rules.Design |
| Class | ObjectTwoPartNameRule |
## Rule Information
| | |
|----|----|
| Id | SRD0039 |
| Friendly Name | Object not schema qualified |
| Category | Design |
| Ignorable | false |
| Applicable Types | Procedure |
| | Scalar Function |
| | Table Valued Function |
| | View |
## Description
Use fully qualified object names in SELECT, UPDATE, DELETE, MERGE and EXECUTE statements. [schema].[name].
## Summary
Use fully qualified object names in SELECT, UPDATE, DELETE, MERGE and EXECUTE statements. [schema].[name]
### Examples
```sql
Create view [dbo].[err]
AS SELECT * FROM [TestTableSSDT]
-- SRD0006, SRD0039
```
### Remarks
There is a minor performance cost with not using two part names. Each time SQL Server runs
across a one part name it has to look up the associated schema to the object.
<sub><sup>Generated by a tool</sup></sub>
