given a table name list datetime time columns

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/

alejo46
Posting Yak Master

157 Posts

Posted - 2015-02-10 : 19:19:09

thank you very much for your help

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources