----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: THESOFTWAREARCHITECT Message 6 in Discussion Dear Prasad, Hi, here is your reply, I managed to get it from my friend. If you select from the sysobjects table, the field xtype can be used to make that determination. This char(2) field uses the following table values: S = System table U = User table V = View This is apart from the fact that most system tables start with sys, other than the dtproperties table. I don't know if you can differentiate between these two types using the INFORMATION_SCHEMA.TABLES or another of the INFORMATION_SCHEMA views. Hope this helps Prasad. DO let me know, if this is thge answer to your question. Best Regards Anil Mahadev Software Dev 2 Da Max ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
