List SQL Server Tables and Field Properties

[Greg]

I have an application I migrated from Access to SQL Server 2005 and have a
report that lists all of my tables and each field name, size, type, default
value and comments. Now that its in SQL i cannot use my report anymore.

Can you please give me an idea from Access on how I could enumerate through
each table in my SQL Database and list each field and its related properties?

Thanks,
Greg

 

[Wei Lu [MSFT]]

Hello Greg,

You could use the system stored procedure in the SQL Server to get the
information.

The sp_columns will get the information.

sp_columns (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms176077.aspx

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[Wei Lu [MSFT]]

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Greg]

I have not yet had a chance to implement your solution with regards to
getting my table names populated. I should be workking on this within the
next few weeks.


Thanks for the suggestion.

 

[Wei Lu [MSFT]]

Hello Greg,

Please let me know the result if you have any question.

Thank you!

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[Aaron Kempf]

just use Access Data Projects

and learn how to query sysobjects and syscolumns