Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking for the existence of a particular field
Message
 
To
20/01/2006 00:21:00
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01088768
Message ID:
01088813
Views:
8
If it is for a SQL server table, you can query the SysObjects and SysColumns tables.
select so.name, sc.name 
from sysobjects AS SO
inner join syscolumns AS SC
ON so.id = sc.id
where SO.xtype = 'u'
and so.name = 'PortfolioDtl'  /* your table name */
and sc.name = 'ClosingDate'   /* your field name */
>Is there a way to check for the existence of a particular field in a table without having to do a SQL select on that table?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform