I did this once before, but forgot how I did it, and can't figure out how I
found the answer either.
Do any of you know how I can print all the table names, columns in the
tables, and data types of the columns from within MS SQL Server Mgmnt
Studio?
Thanks.
~Steve
http://lanctr.com/
Do any of you know how I can print all the table names, columns in the
tables, and data types of the columns from within MS SQL Server Mgmnt
Studio?
Could creating a diagram with all the tables on it help here? This can
show all tables, column data and relationships. Diagrams can be
printed..
Do you can try this statement:
SELECT TABLE_CATALOG,
TABLE_NAME,COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION,
NUMERIC_SCALE,
IS_NULLABLE,
COLUMNPROPERTY(OBJECT_ID(TABLE_NAME), COLUMN_NAME, 'IsIdentity') AS
IS_AUTOINCREMENT,
it into
excel for printing. Again, I THINK I did it this way, but who knows, I've
slept since then.
~Steve
http://lanctr.com/
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 4:02 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
Do any
AHA! This looks familiar... I'll give it a whirl. Thanks!
~Steve
http://lanctr.com/
-Original Message-
From: Web Specialist [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 4:13 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
Do you can try this statement:
SELECT
Yep, that did the trick. You rock!
This time I saved the query ;)
~Steve
http://lanctr.com/
-Original Message-
From: Web Specialist [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 4:13 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
Do you can try this statement
If you're on CF8, cfdbinfo is all you need.
-Original Message-
From: Steve Good [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 4:16 PM
To: CF-Talk
Subject: RE: OT: Printing Database Structure
AHA! This looks familiar... I'll give it a whirl. Thanks!
~Steve
http://lanctr.com
, that did the trick. You rock!
This time I saved the query ;)
~Steve
http://lanctr.com/
-Original Message-
From: Web Specialist [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 4:13 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
Do you can try this statement
Cool, thanks for the tip, I'll look into it.
~Steve
http://lanctr.com/
-Original Message-
From: Web Specialist [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 4:30 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
Cool. Anyway I'll suggest you to know about DataMgr
In CF 8
cfset MyDSN = YourDSN
cfdbinfo
type=tables
datasource=#MyDSN#
name=tableMetaData
table
cfoutput query=tableMetaData
cfdbinfo
type=columns
datasource=#MyDSN#
name=ColumnMetaData
table =
Any way to get number of rows in each table? That would be REALLY useful
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 2:56 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
In CF 8
cfset MyDSN = YourDSN
cfdbinfo
type
useful
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 2:56 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
In CF 8
cfset MyDSN = YourDSN
cfdbinfo
type=tables
datasource=#MyDSN#
name=tableMetaData
of rows in each table? That would be REALLY useful
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 2:56 PM
To: CF-Talk
Subject: Re: OT: Printing Database Structure
In CF 8
cfset MyDSN = YourDSN
cfdbinfo
type=tables
datasource
ER/Studio auto-arranges tables quite well. But, you pay a pretty price
for it.
m!ke
-Original Message-
From: Steve Good [mailto:[EMAIL PROTECTED]
Sent: Friday, April 25, 2008 4:15 PM
To: CF-Talk
Subject: RE: OT: Printing Database Structure
Diagrams can do this, but I don't have
On Jan 18, 2008 6:39 PM, Assistenza Sito [EMAIL PROTECTED] wrote:
http://www.petefreitag.com/item/396.cfm
http://www.whatspop.com/blog/2005/12/my-coldfusion-tagging-enginelibrary.cfm
http://www.whatspop.com/blog/2006/01/setting-up-database-for-tagging.cfm
Thanks Luca. Pete Freitag's post had
2005 about del.icio.us -
http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html
It's talking about mySQL however. We will be using SQL Server 2005,
and in my dreams some smart person has created something like a
database structure with a set of stored procedures for accessing
this article from 2005 about del.icio.us -
http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html
It's talking about mySQL however. We will be using SQL Server 2005,
and in my dreams some smart person has created something like a
database structure with a set of stored procedures
the client tools.
Jeff Polaski
Webmaster
Research Graduate Studies
University California, Irvine
-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:32 PM
To: CF-Talk
Subject: reverse engineering database structure
We're building
We're building a site for a company that uses a very complex inventory
and accounting system that's based on SQL Server. We'd like to use only
a few fields from the database maybe a dozen or so to display some items
on the web. There are a lot of tables, a 100 or so. There aren't very
many
I think I remember being able to do this with Visio 2000 Enterprise version.
You can basically point it at a datasource and it will determine the
database structure and diagram it out...
I'm not sure if the newer versions also have this capability.
HTH,
Jeff Garza
-Original Message
to apply some changes citing some
arcane relationship rules (wouldn't allow multiple foreign keys between
two tables).
-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:49 PM
To: CF-Talk
Subject: RE: reverse engineering database structure
I think
Is there a way to get database structure (tablenames, column names, and
data types) from an Access database using ColdFusion?
T
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources
You can do this with CFObject... check the archives, there have been
several threads about this over the past few years
HTH
Dick
On Wednesday, March 20, 2002, at 08:27 AM, Thane Sherrington wrote:
Is there a way to get database structure (tablenames, column names, and
data types) from
/CFLOOP
/CFOUTPUT
/CFLOOP
/CFIF
/body
/html
- Original Message -
From: Thane Sherrington [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, March 21, 2002 4:27 AM
Subject: Getting database structure from Access
Is there a way to get database structure (tablenames, column
I've been wrestling with this for the last half hour and I can not decide
the best way to structure the database for a function I a programming
related to a shopping cart. It get's kind of crazy...
This was a nightmare question that we almost had to deal with at my last
job. Throw this into
One way to approach this is to use intermediate tables that
contain groups of valid values.
As a simple example, let's take sizes and assume that one
product comes in S,M,L and another product comes in S,M,L,XL.
You could create a size table containing a row for each possible
size:
you should be able to cache the query for stuff like that, so as long as you
do, you shouldn't have to worry about it.
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 7:37 PM
To: CF-Talk
Subject: What the best database structure to do
[mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 8:44 AM
To: CF-Talk
Subject: RE: What the best database structure to do this?
you should be able to cache the query for stuff like that, so as long as you
do, you shouldn't have to worry about it.
-Original Message-
From: Jon Hall
I've been wrestling with this for the last half hour and I can not decide
the best way to structure the database for a function I a programming
related to a shopping cart. It get's kind of crazy...
Each item can have a variable number of sizes.
Each size can have a variable upcharge attached to
Hello cf-talk,
I need to design a product compatability guide for a client. I'm
looking for the best database setup.
1. We need a drill down feature for product brand, product year, and
product model. A user will first choose the Brand, then the year,
then the model.
2. I'll use
I think I will set it up this way:
These tables are no-brainers:
Brand (BrandID, otherbrandinfo)
Year (YearID, year)
Model (ModelID, othermodelinfo)
The intersection tables can get a little confusing. I would set it up this
way, with one Intersection table:
BrandYearModel
: markwarric
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 10:13 AM
To: CF-Talk
Subject: Re: Simple Database Structure Question, Flat or Relational?
I think I will set it up this way:
These tables
10:13 AM
To: CF-Talk
Subject: Re: Simple Database Structure Question, Flat or Relational?
I think I will set it up this way:
These tables are no-brainers:
Brand (BrandID, otherbrandinfo)
Year (YearID, year)
Model (ModelID, othermodelinfo)
The intersection
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 2:11 PM
To: CF-Talk
Subject: Re: Simple Database Structure Question, Flat or Relational?
Mark, are you suggesting one flat table?
Jeff Fongemie
Mark Warrick [EMAIL
://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 2:11 PM
To: CF-Talk
Subject: Re: Simple Database Structure Question, Flat or Relational?
Mark
I am setting up a database in SQL Server that will hold a sales team
listings. The salesperson can be in multiple categories and multiple
states. My question is what is the most efficient way of doing this? would
it be
(1) setting up three tables, one for the salesperson's main record and
-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: database structure
Date: Thu, 07 Jun 2001 12:52:48 -0500
I am setting up a database in SQL Server that will hold a sales team
listings. The salesperson can be in multiple categories and multiple
states. My question is what is the most efficient
Why Sales_Cat_ID?
best, paul
At 02:01 PM 6/7/01 -0500, you wrote:
Go with #1, but make it 4 tables. the fourth being the relationship table
(we'll call it Sales_Cat), that has the salespersonID, the StateID, and the
categoryID, and for good measure, a Sales_Cat_ID.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_000_01C01F30.74D8B7A8
Content-Type: multipart/alternative;
boundary="_=_NextPart_001_01C01F30.74D8B7A8"
make sense?
Rich
-Original Message-
From: Shane Pitts [mailto:[EMAIL PROTECTED]]
Sent: 15 September 2000 17:24
To: RICHARD MOGER
Subject: RE: Best way adding cf structure to existing database
structure?
Definately don't use application variables. Use either client, or session.
If
cannot join the two tables very easily in this format. I
want the user to be able to check a checkbox for each audience they would
like the event to be categorized under.
Can anyone suggest a better database structure or code that would allow the
two tables to be joined under this structure? Please cc
.
The problem is I cannot join the two tables very
easily in this format. I
want the user to be able to check a checkbox for
each audience they would
like the event to be categorized under.
Can anyone suggest a better database structure or
code that would allow the
two tables to be joined under
42 matches
Mail list logo