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 Administration (2000)
 given a table name list datetime time columns

Author  Topic 

alejo46
Posting Yak Master

157 Posts

Posted - 2015-02-09 : 19:31:48
Good evening, i need your help please
given a table name is it possible to list out datetime time columns for that table in sql server 2000 ?

Thanks for your help in advanced

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-09 : 20:37:04
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 'table1' and DATA_TYPE = 'datetime'

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

alejo46
Posting Yak Master

157 Posts

Posted - 2015-02-10 : 19:19:09
thank you very much for your help
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-10 : 19:57:36
You're welcome, glad to help.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -