Query database for List of tables & other details
I want to get a generalised sql query.. for any database.. that will list me..all the table names and their fields,datatype,length, nullable/not at one go.. in SQL 2000 Server..
I have worked out the following query..
"Select a.name as tablename, b.name as fieldname, b.length
from sysobjects a,
syscolumns b where a.xtype ='U' and a.id = b.id order by a.name"
but.. the result is not completely satisfying..