Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Benz, Michael
Sent: 23 July 2012 01:54
To: arslist@ARSLIST.ORG
Subject: Database Names
**
Hello World
Our remedy database is growing a lot faster then we'd like. So we ran a report
that show us our largest tables
, Michael
Sent: Sunday, July 22, 2012 7:54 PM
To: arslist@arslist.org
Subject: Database Names
**
Hello World
Our remedy database is growing a lot faster then we'd like. So we ran a
report that show us our largest tables. The bad side is, is that remedy
did not name them very nicely at all
Hello World
Our remedy database is growing a lot faster then we'd like. So we ran a report
that show us our largest tables. The bad side is, is that remedy did not name
them very nicely at all! Is there any easy way so find out what table is what
form?
EG: dbo.B2109C100351 is 14 GIG and
Hi Michael,
Here you go... select name, schemaid from arschema where schemaid = 'T2109'
Regards
Francois
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Benz, Michael
Sent: Monday, July 23, 2012 2:54 AM
To: arslist@ARSLIST.ORG
Subject: Database
: Database Names
**
Hello World
Our remedy database is growing a lot faster then we’d like. So we ran a report
that show us our largest tables. The bad side is, is that remedy did not name
them very nicely at all! Is there any easy way so find out what table is what
form?
EG: dbo.B2109C100351
23, 2012 3:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Database Names
**
Hi Michael,
That's an attachment field on a form with the schema ID of 2109. You can run
the following SQL statement to determine which form it is.
select name from arschema where schemaId = '2109'
T2109 holds record data
Hi everyone,
Yes, this is a simplistic question but I don't have my dev server to test it
on right now because it's been upgraded. I generally don't do this but I
have been requested to change about 20 fields. It's all right to have the
field label and the field database name out of sync on a
System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Friday, February 16, 2007 11:45 AM
To: arslist@ARSLIST.ORG
Subject: Changing field database names
**
Hi everyone,
Yes, this is a simplistic question but I don't have my dev server to
test it on right now
:[EMAIL PROTECTED] On Behalf Of Susan Palmer
Sent: Friday, February 16, 2007 11:45 AM
To: arslist@ARSLIST.ORG
Subject: Changing field database names
**
Hi everyone,
Yes, this is a simplistic question but I don't have my dev server to
test it on right now because it's been upgraded. I generally
Shellman, David [EMAIL PROTECTED]
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG
02/16/2007 08:54 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: Changing field database names
**
Susan,
Yes you can change the database fieldname
10 matches
Mail list logo