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.
| Author |
Topic |
|
verybrightstar
Starting Member
16 Posts |
 Posted - 2005-03-02 : 05:30:50
|
| hi all,is that any transact sql statement to view the data type using sql statement. for ef i would like to know in the employer profile table i would like to know each column the data type what is it ? eg.emp_name --- varchar (80)emp_address --- varchar(150)kt |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-02 : 05:38:52
|
| Various ways, will this help ?exec sp_help 'tablename'exec sp_mshelpcolumns 'tablename'select * from information_schema.columns where table_name = 'tablename'rockmoose |
 |
|
|
verybrightstar
Starting Member
16 Posts |
Posted - 2005-03-02 : 06:53:55
|
thanks for ur help  quote:
Originally posted by rockmoose
Various ways, will this help ?exec sp_help 'tablename'exec sp_mshelpcolumns 'tablename'select * from information_schema.columns where table_name = 'tablename'rockmoose
kt |
|
|
|
|
|
|
view the data type table column in using sql