Description
Properties
| Name | Value |
|---|---|
| Collation | SQL_Latin1_General_CP1_CI_AS |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 11/6/2020 19:07:47 |
| Last Modified | 11/6/2020 19:07:47 |
Columns
| Key | Name | Description |
|---|---|---|
| id | ||
| file_name | ||
| username | ||
| createdate | ||
| file_type_id |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.vw_part_list_upload
AS
SELECT
dbo.dt_fileupload.id
, dbo.dt_fileupload.file_name
, dbo.users.username
, dbo.dt_fileupload.createdate
, dbo.dt_fileupload.file_type_id
FROM dbo.dt_fileupload
LEFT OUTER JOIN dbo.users ON dbo.dt_fileupload.createby = dbo.users.id
GO
GO
CREATE VIEW dbo.vw_part_list_upload
AS
SELECT
dbo.dt_fileupload.id
, dbo.dt_fileupload.file_name
, dbo.users.username
, dbo.dt_fileupload.createdate
, dbo.dt_fileupload.file_type_id
FROM dbo.dt_fileupload
LEFT OUTER JOIN dbo.users ON dbo.dt_fileupload.createby = dbo.users.id
GO
Depends On
2Used By
No items found