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,
COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
ORDER BY 2,3
Cheers
Marco Antonio
On Fri, Apr 25, 2008 at 5:43 PM, Steve Good <[EMAIL PROTECTED]> wrote:
> 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/
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304268
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
