WHERE 'daTable' = TABLE_NAME
Thank you! This isn't exactly what i needed, BUT it gave me enough information to figure out how to do what i wanted to do.
rs.Open sqlfood, MyConn
while not rs.eof
response.write rs("Column_Name") & ": type="& rs("data_Type") &"<br>"
for each f in rs.Fields
' gives the names of the schema fields to response.write above
Response.Write(f.Name & ":")
try this too
SELECT b.name, c.name as TypeName,
FROM sysobjects a
syscolumns b ON a.id = b.id
systypes c ON b.xusertype = c.xusertype
WHERE a.id = object_id(N'[dbo].[emptable]')
ORDER BY b.colId
I see it a bit like using ANSI compatible syntax. Do it when you can, but don't avoid the T-SQL extensions on principle. Ditto with this topic - as George says, not everything is in INFORMATION_SCHEMA.