|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | uvw_CODE_State |
| Schema | dbo |
| Quoted Identifier Status | True |
| Ansi Nulls Status | True |
| Returns View Metadata | False |
| Create Date | 8/1/2012 11:48 AM |
| Description |
Columns
Column Name |
Data Type |
Allow Nulls |
Fulltext Indexed |
Identity |
Description / Computed Formula |
varchar(10) |
True |
False |
False |
||
varchar(30) |
True |
False |
False |
Triggers
| Name | Insert | Update | Delete | Instead |
Indexes
| Name | Clustered | Columns |
Parent Dependencies (objects that dbo.uvw_CODE_State depends on)
| Name | Type |
Table |
|
StoredProcedure |
Child Dependencies (objects that depend on dbo.uvw_CODE_State)
| Name | Type |
STOREDPROCEDURE |
|
TABLE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: View [dbo].[uvw_CODE_State] Script Date: 03/09/2017 16:47:10 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE VIEW [dbo].[uvw_CODE_State] AS SELECT cod.CODE ,cod.DESCRIPTION AS STATE_DESCRIPTION FROM UTL_CODE_TABLE cod WHERE cod.STATUS = 'A' AND cod.TABLE_NAME = 'STATE' |
| Powered by BI Documenter |
