# SQL Server Rule: SML047
| | |
|----|----|
| Assembly | TSQLSmellSCA |
| Namespace | TSQLSmellSCA |
| Class | TSQLSmellSCA47 |
## Rule Information
| | |
|----|----|
| Id | SML047 |
| Friendly Name | Use of deprecated data type |
| Category | CodeSmells |
| Ignorable | false |
| Applicable Types | Model |
## Description
Use of deprecated data type
### Examples
```sql
Create Table dbo.SomeText
(
ID integer primary key,
[SomeText] TEXT NULL
)
-- SML047, SRD0051, SRN0007
```
```sql
Create Procedure dbo.DepTypes
as
Set nocount on
Declare @DP1 text
Declare @DP2 ntext
-- SML047, SRD0012
```
<sub><sup>Generated by a tool</sup></sub>
