|
|
|||||
|
|
|||||
Properties
| Property | Value |
| Name | uvw_CODE_Country |
| Schema | dbo |
| Quoted Identifier Status | True |
| Ansi Nulls Status | True |
| Returns View Metadata | False |
| Create Date | 8/1/2012 11:50 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_Country depends on)
| Name | Type |
Table |
|
StoredProcedure |
Child Dependencies (objects that depend on dbo.uvw_CODE_Country)
| Name | Type |
STOREDPROCEDURE |
|
TABLE |
Extended Properties
| Object | Property | Value |
Annotations
| Object | Property | Value |
DDL
|
/****** Object: View [dbo].[uvw_CODE_Country] Script Date: 03/09/2017 16:47:09 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE VIEW [dbo].[uvw_CODE_Country] AS SELECT cod.CODE ,cod.DESCRIPTION AS COUNTRY_DESCRIPTION FROM UTL_CODE_TABLE cod WHERE cod.STATUS = 'A' AND cod.TABLE_NAME = 'COUNTRY-ST' |
| Powered by BI Documenter |
