I want to return info about a SQL 2005 dtabases's tables.
This code returns the a table who's columns are TableName, ColumnName, ColumnDesc and Sequence. What do
I need to add to get Column Size, Precision, Null/Not Null, PK info, ect?
SELECT o.Name AS ObjectName,
c.name AS ColumnName,
ep.value AS ColumnDesc,
c.colid AS Sequence
FROM sys.objects o INNER JOIN sys.extended_properties ep
ON o.object_id = ep.major_id
INNER JOIN sys.schemas s
ON o.schema_id = s.schema_id
LEFT JOIN syscolumns c
ON ep.minor_id = c.colid
AND ep.major_id = c.id
WHERE o.type = 'U'
ORDER BY ObjectName, Sequence
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people