Stack Overflow
Stack Overflow

Questions tagged [data-dictionary]

A Data Dictionary stores information about all user-defined objects in the database. It usually comes with utilities to cross-reference all system components to each other.

References

187 questions
0
votes
1 answer

Creating Data Dictionary from SQL Server Database

I would like to create a Data Dictionary using Python from the SQL Server Database. I've written the following code but it gives me the following result, [OrderedDict([('SystemID', '1'), ('FileID', 1), ('DateTime', None)])] But I want my result…
user1345260
  • 2,151
  • 12
  • 33
  • 42
0
votes
1 answer

Create Data dictionary of database B

I have 2 database server main database A and other database B. Database B is same as A but the name of tables and some of the field name are different, but data inside is almost the same. Database B as some minor modification to number of…
Mowgli
  • 3,422
  • 21
  • 64
  • 88
0
votes
1 answer

What is the best way to create an enhanced Data Dictionary?

Without going into specifics...I have a large SQL Server 2005 database with umpteen stored-procedures. I have multiple applications from WinForm apps to WebServices all of which use this DB. My simple objective now is to create a meta-database...a…
Jarvis Bot
  • 481
  • 6
  • 15
0
votes
1 answer

What is the recommended way of finding unused functions and procedures in packages?

I have a few packages which begin with the name ´LTR_´. I'm trying to clean up my codebase and would like to find if there are any unused functions and procedures. Is it possible to query the data-dictionary to find any methods in the LTR_ packages…
Mridang Agarwalla
  • 43,201
  • 71
  • 221
  • 382
0
votes
2 answers

how to read/write data dictionary in android programmatically

I want to read/write data dictionary in file which is in android internal/external memory. In WP7, they have used IsolatedStorage for storing the dictionary directly. In IOS, they can write NSDictionary directly to the file. Please anyone tell me…
Ponmalar
  • 6,871
  • 10
  • 50
  • 80
0
votes
1 answer

Microsoft Sync Framework - ServerBlob is Empty Error

I am using Microsoft Sync Framework to sync the details from the Datadictionary on android device with SQL Server. Initially get success to sync all data from sql server. But after adding some data and when clicking on the Sync button getting the…
Ponmalar
  • 6,871
  • 10
  • 50
  • 80
0
votes
3 answers

Creating index in a data dictionary with Clipper

I am converting existing Clipper code from free tables to data dictionary. I can read and write to tables but I can't create an index. Here is the code : connSaisie := DacSession():new(GetSsoConnection(1)) connSaisie:SetDefault() DbeInfo(…
kuzkot
  • 81
  • 4
0
votes
1 answer

How to get values of DataDictionary from web page to android

I want to parse the data from Html page in Android application. I am sending datadictionary values as below var fields = {"data1" : "1","data2" : "2"}; how to get the data1 and data2 values in android application? Note: If i passed this fields to…
Ponmalar
  • 6,871
  • 10
  • 50
  • 80
0
votes
1 answer

Oracle: Script similar to describe command

I'm being asked to create a script that basically does the same thing as the describe command. I have figured out how to write the script and get the output I want, but the second part of the assignment is to "duplicate the format of the describe…
user1801794
  • 25
  • 3
0
votes
1 answer

Is the dba_transformations dictionary view only accessible when you log in AS SYSDBA?

I'm trying to query the data dictionary to find information on the transformations in the database. I've given my user DBA privileges, so I can access the DBA_ dictionary views. With this user, I can access all the DBA_ views without issues, however…
thecoop
  • 45,220
  • 19
  • 132
  • 189
0
votes
1 answer

How to hide the "Data Dictionary" from the Alfresco Repository?

I am new to alfresco. I am integrating Alfresco with the web application as an library for my application. I am logging to alfresco as a admin and I can see the Data Dictionary in my repository. I want to hide it. Is it possible?
than1234
  • 53
  • 2
  • 10
0
votes
1 answer

About Data Dictionary

I'm working with Dynamics ax 2012. I'm finding a way to create foreign key with dynamics ax. I try to create new -> relation -> new -> foreignkey -> primarykey based I successfully created this relation but when I look the database in SQLSERVER2008…
jawhar_m2
  • 23
  • 5
0
votes
1 answer

should i write FK, NULL or NOT_NULL?

i'm trying to do a data dictionary and am filling the tables with ( attributes , Null, Type , length) one of the tables i got is like create table user( user_number(8), First_name varchar(30) not null, Last_name varchar(30) not null, …
yugi Salliue
  • 1
0
votes
2 answers

Is there a way to find only part of the key value in a dictionary object?

There a dictionary object that gets loaded with the following key values: 119 189a 189b 189c 197 201a 201b In most situations, life is good and all the individual key values are needed/unique. But in certain situations, the keys with letters behind…
user1070202
  • 157
  • 1
  • 4
-1
votes
2 answers

oracle - find Information about tables an columns

I use the SQL Developer for various queries in our database schema. The tables are listed under the Objects container. There I can left-click and select view with then display information about the table under the Columns tab. The comments are…
Michael
  • 23
  • 1
  • 6
1 2 3
…
12
13