Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to get the tables/views structure including field names and their datatypes from a database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-14 : 23:53:40
selva writes "Hi All,

I wanted to generate a report to show an abstract of database structure, which include all the user tables and views names and their field names with respective data types and settings for their nullability etc. Can someone shed some light on this. If there is any SQL or stored procedure to do this it would also be fine.

Thanks
Selva"
   

- Advertisement -