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 column information in MS SQL

Author  Topic 

rpoon
Starting Member

3 Posts

Posted - 2002-02-07 : 17:11:31
Is there a query that will return information about a column's size? Like what type a column is -- like varchar. And how big it can be? like 255?

Thanks,

chadmat
The Chadinator

1974 Posts

Posted - 2002-02-07 : 17:21:31
SELECT *
FROM Northwind.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'Customers'

HTH
-Chad

Go to Top of Page

rpoon
Starting Member

3 Posts

Posted - 2002-02-07 : 17:23:01
Sweet. Thanks!

Go to Top of Page
   

- Advertisement -