Description
Properties
| Name | Value |
|---|---|
| File Collation | |
| File Group | |
| Filestream File Group | |
| Is Partitioned | False |
| Partitioned Column | |
| Partition Scheme | |
| File Groups | |
| Filestream Partition Scheme | |
| Filestream File Groups | |
| Heap | True |
| Full Text Catalog | |
| Full Text | |
| Compression | NONE |
| Row Count (~) | 792 |
| Created | 3/20/2018 5:23:24 PM |
| Last Modified | 3/20/2018 5:23:24 PM |
Columns
10| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| vendor | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| Column1 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column2 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column3 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column4 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column5 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column6 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| taxid | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column8 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Column9 | varchar | 50 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.brgdatacleaning (
vendor varchar(250) NULL,
Column1 varchar(50) NULL,
Column2 varchar(50) NULL,
Column3 varchar(50) NULL,
Column4 varchar(50) NULL,
Column5 varchar(50) NULL,
Column6 varchar(50) NULL,
taxid varchar(50) NULL,
Column8 varchar(50) NULL,
Column9 varchar(50) NULL
)
ON [PRIMARY]
GO
vendor varchar(250) NULL,
Column1 varchar(50) NULL,
Column2 varchar(50) NULL,
Column3 varchar(50) NULL,
Column4 varchar(50) NULL,
Column5 varchar(50) NULL,
Column6 varchar(50) NULL,
taxid varchar(50) NULL,
Column8 varchar(50) NULL,
Column9 varchar(50) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found