Groups > Databases > MySQL for ASP.NET > Re: How to get one column from sp_columns




How to get one column from sp_columns

How to get one column from sp_columns
Tue, 26 Feb 2008 18:17:53 +000
Hi,

When I run sp_columns @table_name = someTable, I get many columns like
TABLE_QUALIFIER, TABLE_OWNER and so on.


Is there a easy way to get only a COLUMN_NAME column?

Thanks
Post Reply
Re: How to get one column from sp_columns
Tue, 26 Feb 2008 22:57:47 +000
Your post is on Mysql topics. But your syntax is like MsSql Server !!! 

So in MySql try 

DESCRIBE table_name column_name;

 In MsSQL Server try : see help on "sp_help"
Post Reply
about | contact