MeanJoeGreen13
IS-IT--Management
- Jan 6, 2008
- 15
How can I get the data type [size] [null or not null], schema from a table columns?
Please, if this is posible, show me an example.
Please, if this is posible, show me an example.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Type 1
- Thread starter MeanJoeGreen13
- Start date
- Status
-
1
- #2
mrdenny
Programmer
- May 27, 2002
- 11,595
In SQL 2000 you can use the INFORMATION_SCHEMA.COLUMNS view.
In SQL 2005 you can use the sys.columns view.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
In SQL 2005 you can use the sys.columns view.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Status