Hi, is there a way to retrieve the data type of table columns? the information in SYSCOLUMN are not enough, because they don't tell whether the column is CHAR or INT or DATE. Even in SYSOBJECT I couldnt find such info. The only way to get this info is DESCRIBE TABLENAME, but I need to inquire the data type inside a procedure, so I need it as select statement. asked 26 Nov '20, 03:21 Baron |
Ah, found it, the view SYSCOLUMNS has the full answer!! answered 26 Nov '20, 04:19 Baron |
Well, for current versions, system view SYSTABCOL would be the natural choice - note, it returns variable-sized types including their declared width, such as "char(1)" or "varchar(128)". Using SYSCOLUMNS tends to be error-prone IMHO as there might be two such views, one owned by SYS and the other by dbo... answered 26 Nov '20, 05:15 Volker Barth Yes, I preceed it with the owner name, so I use SYS.SYSCOLUMNS. Thank you
(26 Nov '20, 09:07)
Baron
|