|
| 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
|
|
|
|
|
|
|
|
|
|