dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: SQL
Expertise: Advanced
Oct 18, 2005

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Find All User Tables, Columns, DataTypes, and Length

To determine all your user tables, plus their columns, datatypes, and length, type:

SELECT DISTINCT SO.Name AS "TableName",
		 SC.ColID,
		 SC.Name AS "ColumnName", 
		 ST.Name AS "DataType", 
		 SC.Length AS "Length",
		 SC.Status AS "Status" 
FROM   SysObjects SO JOIN
		(sysColumns SC JOIN sysTypes ST 
		 ON SC.UserType = ST.UserType)
		 ON SO.ID = SC.ID
WHERE  SO.Xtype = 'U'
ORDER BY SO.Name,SC.ColID
Alternatively, you could write a small application to split this query into two parts. The first part would get all the table names and IDs using sysobjects (to provide a heading if you're saving this into, say, MS Word). The second part would retrieve all the column names and datatypes using those IDs.

Daljinder Singh
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date