RE: Witango-Talk: SQL field type

Mon, 23 Dec 2002 12:46:05 -0800

Title: Message

Yes…. If you’re using MSSQL try:

 

Select Name from sysobjects where Xtype = 'U' order by Name

 

This will give you a list of tables, but not the field definitions. I did it once. Can’t remember now.

 

Search in MSSQL “books online” for the word “sysobjects” and I think there’s an example.

 

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of stephenyoung
Sent: Friday, December 20, 2002 5:15 AM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: SQL field type

 

Does anyone know how to discover information about a field, ie its type and size using sql?

 

Steve

Reply via email to