Click here to Skip to main content
15,886,840 members
Articles / Desktop Programming / Win32

SQL Class Shell Generator

Rate me:
Please Sign up or sign in to vote.
4.87/5 (65 votes)
8 Jan 2009CPOL6 min read 218.4K   3.3K   233  
Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.
��<HTML><HEAD>

<META NAME="COPYRIGHT" CONTENT="2008 � Paw Jershauge">

<META NAME="DESCRIPTION" CONTENT="This site contains information about the SQLReader  Class Library.">

<META NAME="AUTHOR" CONTENT="Paw Jershauge">

<META NAME="CODING" CONTENT="Paw Jershauge">

<META NAME="DEVELOPER" CONTENT="Paw Jershauge [http://paw.jershauge.dk]">

<META NAME="GENERATOR" CONTENT="Assembly To HTML by Paw Jershauge">

<LINK REL="STYLESHEET" TYPE="TEXT/CSS" HREF="../dat/msdn2.css"></LINK><SCRIPT LANGUAGE="Javascript1.2" SRC="../dat/jscr.js"></SCRIPT>

<TITLE>SQLReader by Paw Jershauge</TITLE></HEAD><BODY CLASS="typeenumeration" onload="wo('SQLReader.Object_Type_toolbar.htm','TOOLBAR')" onunload="wo('../toolbar.htm','TOOLBAR');CurrentObject('...');">

<P CLASS="medium"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="collapse_expandimg" NAME="collapse_expandimg"><A NAME="collapse_expand" href="#collapse_expand" onclick="plusminustglcontentshowing();tglContent();" CLASS="liketext">Collapse/Expand content</A></P>

SQLReader  Class Library

<H1>Object_Type Enumeration</H1>

<P><B>Namespace:</B> <A HREF="SQLReader.htm">SQLReader</A></P>

<P><B>Assembly:</B> <A HREF="SQLReader(1.0.0.0).htm">SQLReader</A> ( in SQLReader.dll )</P>

<P><B>Basetype(s): </B><A HREF="http://msdn2.microsoft.com/en-us/library/System.Enum.aspx" TARGET="_blank">System.Enum</A></P>

<P><B>Inheritance(s): </B><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">System.Byte</A></P>

<P><A HREF="#" onclick="codetglsync();"><IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR">Show/Hide Code</A></P>

<H3>In this document the following highlight are available:</H3>

<UL><LI><A HREF="#ANAME_FieldBox">Fields (24)</A></LI><LI><A HREF="#ANAME_EnumItemsBox">Enum items (24)</A></LI><LI><A HREF="#ANAME_SeeAlso_RefBox">See also</A></LI></UL><A NAME="ANAME_EnumItemsBox"></A><H2 CLASS="clk" onclick="plusminustgl('EnumItemsBox');"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="EnumItemsImg" NAME="EnumItemsBoxImg">Enum Items</H2>

<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%" ID="EnumItemsBox" NAME="EnumItemsBox"><TR><TD CLASS="tdhead">&nbsp;</TD><TD CLASS="tdhead">Name</TD><TD CLASS="tdhead">Type</TD><TD CLASS="tdhead">Value</TD><TD CLASS="tdhead">Description</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">AF</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">0 <I>(0x00000000)</I></TD><TD CLASS="tditem">Aggregate function (CLR)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">C</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">1 <I>(0x00000001)</I></TD><TD CLASS="tditem">CHECK constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">D</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">2 <I>(0x00000002)</I></TD><TD CLASS="tditem">DEFAULT (constraint or stand-alone)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">F</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">3 <I>(0x00000003)</I></TD><TD CLASS="tditem">FOREIGN KEY constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">FN</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">7 <I>(0x00000007)</I></TD><TD CLASS="tditem">SQL scalar function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">FS</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">8 <I>(0x00000008)</I></TD><TD CLASS="tditem">Assembly (CLR) scalar function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">FT</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">9 <I>(0x00000009)</I></TD><TD CLASS="tditem">Assembly (CLR) table-valued function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">IF</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">17 <I>(0x00000011)</I></TD><TD CLASS="tditem">SQL inline table-valued function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">IT</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">23 <I>(0x00000017)</I></TD><TD CLASS="tditem">Internal table&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">P</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">5 <I>(0x00000005)</I></TD><TD CLASS="tditem">SQL stored procedure&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">PC</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">6 <I>(0x00000006)</I></TD><TD CLASS="tditem">Assembly (CLR) stored procedure&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">PK</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">4 <I>(0x00000004)</I></TD><TD CLASS="tditem">PRIMARY KEY constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">R</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">10 <I>(0x0000000a)</I></TD><TD CLASS="tditem">Rule (old-style, stand-alone)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">RF</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">11 <I>(0x0000000b)</I></TD><TD CLASS="tditem">Replication-filter-procedure&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">S</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">12 <I>(0x0000000c)</I></TD><TD CLASS="tditem">System base table&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">SN</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">13 <I>(0x0000000d)</I></TD><TD CLASS="tditem">Synonym&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">SQ</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">14 <I>(0x0000000e)</I></TD><TD CLASS="tditem">Service queue&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">TA</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">15 <I>(0x0000000f)</I></TD><TD CLASS="tditem">Assembly (CLR) DML trigger&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">TF</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">18 <I>(0x00000012)</I></TD><TD CLASS="tditem">SQL table-valued-function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">TR</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">16 <I>(0x00000010)</I></TD><TD CLASS="tditem">SQL DML trigger&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">U</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">19 <I>(0x00000013)</I></TD><TD CLASS="tditem">Table (user-defined)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">UQ</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">20 <I>(0x00000014)</I></TD><TD CLASS="tditem">UNIQUE constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">V</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">21 <I>(0x00000015)</I></TD><TD CLASS="tditem">View&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"></TD><TD CLASS="tditem">X</TD><TD CLASS="tditem"><A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">Byte</A></TD><TD CLASS="tditem">22 <I>(0x00000016)</I></TD><TD CLASS="tditem">Extended stored procedure&nbsp;</TD></TR>

</TABLE>

<A NAME="ANAME_FieldBox"></A><H2 CLASS="clk" onclick="plusminustgl('FieldBox');"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="FieldBoxImg" NAME="FieldBoxImg">Fields</H2>

<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%" ID="FieldBox" NAME="FieldBox"><TR><TD CLASS="tdhead">&nbsp;</TD><TD CLASS="tdhead">Name</TD><TD CLASS="tdhead">Type</TD><TD CLASS="tdhead">Description</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">AF</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Aggregate function (CLR)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">C</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">CHECK constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">D</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">DEFAULT (constraint or stand-alone)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">F</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">FOREIGN KEY constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">FN</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">SQL scalar function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">FS</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Assembly (CLR) scalar function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">FT</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Assembly (CLR) table-valued function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">IF</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">SQL inline table-valued function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">IT</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Internal table&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">P</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">SQL stored procedure&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">PC</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Assembly (CLR) stored procedure&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">PK</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">PRIMARY KEY constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">R</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Rule (old-style, stand-alone)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">RF</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Replication-filter-procedure&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">S</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">System base table&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">SN</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Synonym&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">SQ</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Service queue&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">TA</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Assembly (CLR) DML trigger&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">TF</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">SQL table-valued-function&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">TR</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">SQL DML trigger&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">U</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Table (user-defined)&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">UQ</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">UNIQUE constraint&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">V</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">View&nbsp;</TD></TR>

<TR><TD CLASS="tditemimg"><IMG SRC="../objimg/EnumItem.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Enumeration Item Field"><IMG SRC="../objimg/static.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="mid" TITLE="Static"></TD><TD CLASS="tditem">X</TD><TD CLASS="tditem"><A HREF="SQLReader.Object_Type.htm" TARGET="_self">Object_Type</A></TD><TD CLASS="tditem">Extended stored procedure&nbsp;</TD></TR>

</TABLE>

<H2>CodeDom of Object_Type Enumeration</H2>

<BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="cscodeimg" NAME="cscodeimg"><A NAME="bookcscode" href="#bookcscode" onclick="codetgl('cscode');" CLASS="codetoggle">C# (CSharp) code</a>

<DIV NAME="cscode" ID="cscode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">//C# (CSharp)</FONT>

public enum Object_Type : byte {

    

    // Hex value is: 00000000

    [Description("Aggregate function (CLR)")]

    AF = 0,

    

    // Hex value is: 00000001

    [Description("CHECK constraint")]

    C = 1,

    

    // Hex value is: 00000002

    [Description("DEFAULT (constraint or stand-alone)")]

    D = 2,

    

    // Hex value is: 00000003

    [Description("FOREIGN KEY constraint")]

    F = 3,

    

    // Hex value is: 00000004

    [Description("PRIMARY KEY constraint")]

    PK = 4,

    

    // Hex value is: 00000005

    [Description("SQL stored procedure")]

    P = 5,

    

    // Hex value is: 00000006

    [Description("Assembly (CLR) stored procedure")]

    PC = 6,

    

    // Hex value is: 00000007

    [Description("SQL scalar function")]

    FN = 7,

    

    // Hex value is: 00000008

    [Description("Assembly (CLR) scalar function")]

    FS = 8,

    

    // Hex value is: 00000009

    [Description("Assembly (CLR) table-valued function")]

    FT = 9,

    

    // Hex value is: 0000000a

    [Description("Rule (old-style, stand-alone)")]

    R = 10,

    

    // Hex value is: 0000000b

    [Description("Replication-filter-procedure")]

    RF = 11,

    

    // Hex value is: 0000000c

    [Description("System base table")]

    S = 12,

    

    // Hex value is: 0000000d

    [Description("Synonym")]

    SN = 13,

    

    // Hex value is: 0000000e

    [Description("Service queue")]

    SQ = 14,

    

    // Hex value is: 0000000f

    [Description("Assembly (CLR) DML trigger")]

    TA = 15,

    

    // Hex value is: 00000010

    [Description("SQL DML trigger")]

    TR = 16,

    

    // Hex value is: 00000011

    [Description("SQL inline table-valued function")]

    IF = 17,

    

    // Hex value is: 00000012

    [Description("SQL table-valued-function")]

    TF = 18,

    

    // Hex value is: 00000013

    [Description("Table (user-defined)")]

    U = 19,

    

    // Hex value is: 00000014

    [Description("UNIQUE constraint")]

    UQ = 20,

    

    // Hex value is: 00000015

    [Description("View")]

    V = 21,

    

    // Hex value is: 00000016

    [Description("Extended stored procedure")]

    X = 22,

    

    // Hex value is: 00000017

    [Description("Internal table")]

    IT = 23,

}

</PRE>

</DIV>

<BR><BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="vbcodeimg" NAME="vbcodeimg"><A NAME="bookvbcode" href="#bookvbcode" onclick="codetgl('vbcode');" CLASS="codetoggle">VB (Visual Basic) code</a>

<DIV NAME="vbcode" ID="vbcode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">'VB (Visual Basic)</FONT>

Public Enum Object_Type As Byte

    

    'Hex value is: 00000000

    &lt;Description("Aggregate function (CLR)")&gt;  _

    AF = 0

    

    'Hex value is: 00000001

    &lt;Description("CHECK constraint")&gt;  _

    C = 1

    

    'Hex value is: 00000002

    &lt;Description("DEFAULT (constraint or stand-alone)")&gt;  _

    D = 2

    

    'Hex value is: 00000003

    &lt;Description("FOREIGN KEY constraint")&gt;  _

    F = 3

    

    'Hex value is: 00000004

    &lt;Description("PRIMARY KEY constraint")&gt;  _

    PK = 4

    

    'Hex value is: 00000005

    &lt;Description("SQL stored procedure")&gt;  _

    P = 5

    

    'Hex value is: 00000006

    &lt;Description("Assembly (CLR) stored procedure")&gt;  _

    PC = 6

    

    'Hex value is: 00000007

    &lt;Description("SQL scalar function")&gt;  _

    FN = 7

    

    'Hex value is: 00000008

    &lt;Description("Assembly (CLR) scalar function")&gt;  _

    FS = 8

    

    'Hex value is: 00000009

    &lt;Description("Assembly (CLR) table-valued function")&gt;  _

    FT = 9

    

    'Hex value is: 0000000a

    &lt;Description("Rule (old-style, stand-alone)")&gt;  _

    R = 10

    

    'Hex value is: 0000000b

    &lt;Description("Replication-filter-procedure")&gt;  _

    RF = 11

    

    'Hex value is: 0000000c

    &lt;Description("System base table")&gt;  _

    S = 12

    

    'Hex value is: 0000000d

    &lt;Description("Synonym")&gt;  _

    SN = 13

    

    'Hex value is: 0000000e

    &lt;Description("Service queue")&gt;  _

    SQ = 14

    

    'Hex value is: 0000000f

    &lt;Description("Assembly (CLR) DML trigger")&gt;  _

    TA = 15

    

    'Hex value is: 00000010

    &lt;Description("SQL DML trigger")&gt;  _

    TR = 16

    

    'Hex value is: 00000011

    &lt;Description("SQL inline table-valued function")&gt;  _

    [IF] = 17

    

    'Hex value is: 00000012

    &lt;Description("SQL table-valued-function")&gt;  _

    TF = 18

    

    'Hex value is: 00000013

    &lt;Description("Table (user-defined)")&gt;  _

    U = 19

    

    'Hex value is: 00000014

    &lt;Description("UNIQUE constraint")&gt;  _

    UQ = 20

    

    'Hex value is: 00000015

    &lt;Description("View")&gt;  _

    V = 21

    

    'Hex value is: 00000016

    &lt;Description("Extended stored procedure")&gt;  _

    X = 22

    

    'Hex value is: 00000017

    &lt;Description("Internal table")&gt;  _

    IT = 23

End Enum

</PRE>

</DIV>

<BR><BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="vjscodeimg" NAME="vjscodeimg"><A NAME="bookvjscode" href="#bookvjscode" onclick="codetgl('vjscode');" CLASS="codetoggle">VJ (Visual JSharp) code</a>

<DIV NAME="vjscode" ID="vjscode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">//J# (Visual J#)</FONT>

public enum Object_Type {

    

    // Hex value is: 00000000

    /** @attribute Description("Aggregate function (CLR)")*/

    AF(0),

    

    // Hex value is: 00000001

    /** @attribute Description("CHECK constraint")*/

    C(1),

    

    // Hex value is: 00000002

    /** @attribute Description("DEFAULT (constraint or stand-alone)")*/

    D(2),

    

    // Hex value is: 00000003

    /** @attribute Description("FOREIGN KEY constraint")*/

    F(3),

    

    // Hex value is: 00000004

    /** @attribute Description("PRIMARY KEY constraint")*/

    PK(4),

    

    // Hex value is: 00000005

    /** @attribute Description("SQL stored procedure")*/

    P(5),

    

    // Hex value is: 00000006

    /** @attribute Description("Assembly (CLR) stored procedure")*/

    PC(6),

    

    // Hex value is: 00000007

    /** @attribute Description("SQL scalar function")*/

    FN(7),

    

    // Hex value is: 00000008

    /** @attribute Description("Assembly (CLR) scalar function")*/

    FS(8),

    

    // Hex value is: 00000009

    /** @attribute Description("Assembly (CLR) table-valued function")*/

    FT(9),

    

    // Hex value is: 0000000a

    /** @attribute Description("Rule (old-style, stand-alone)")*/

    R(10),

    

    // Hex value is: 0000000b

    /** @attribute Description("Replication-filter-procedure")*/

    RF(11),

    

    // Hex value is: 0000000c

    /** @attribute Description("System base table")*/

    S(12),

    

    // Hex value is: 0000000d

    /** @attribute Description("Synonym")*/

    SN(13),

    

    // Hex value is: 0000000e

    /** @attribute Description("Service queue")*/

    SQ(14),

    

    // Hex value is: 0000000f

    /** @attribute Description("Assembly (CLR) DML trigger")*/

    TA(15),

    

    // Hex value is: 00000010

    /** @attribute Description("SQL DML trigger")*/

    TR(16),

    

    // Hex value is: 00000011

    /** @attribute Description("SQL inline table-valued function")*/

    IF(17),

    

    // Hex value is: 00000012

    /** @attribute Description("SQL table-valued-function")*/

    TF(18),

    

    // Hex value is: 00000013

    /** @attribute Description("Table (user-defined)")*/

    U(19),

    

    // Hex value is: 00000014

    /** @attribute Description("UNIQUE constraint")*/

    UQ(20),

    

    // Hex value is: 00000015

    /** @attribute Description("View")*/

    V(21),

    

    // Hex value is: 00000016

    /** @attribute Description("Extended stored procedure")*/

    X(22),

    

    // Hex value is: 00000017

    /** @attribute Description("Internal table")*/

    IT(23)

}

</PRE>

</DIV>

<BR><BR>

<IMG SRC="../objimg/Folder_closed.png" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="vccodeimg" NAME="vccodeimg"><A NAME="bookvccode" href="#bookvccode" onclick="codetgl('vccode');" CLASS="codetoggle">VC (Visual C) code</a>

<DIV NAME="vccode" ID="vccode" STYLE="display:none;">

<PRE CLASS="code">

<FONT COLOR="darkgreen">//VC (Visual C)</FONT>

public enum class Object_Type sealed : System::Byte {

    

    // Hex value is: 00000000

    [Description(L"Aggregate function (CLR)")]

    AF = 0,

    

    // Hex value is: 00000001

    [Description(L"CHECK constraint")]

    C = 1,

    

    // Hex value is: 00000002

    [Description(L"DEFAULT (constraint or stand-alone)")]

    D = 2,

    

    // Hex value is: 00000003

    [Description(L"FOREIGN KEY constraint")]

    F = 3,

    

    // Hex value is: 00000004

    [Description(L"PRIMARY KEY constraint")]

    PK = 4,

    

    // Hex value is: 00000005

    [Description(L"SQL stored procedure")]

    P = 5,

    

    // Hex value is: 00000006

    [Description(L"Assembly (CLR) stored procedure")]

    PC = 6,

    

    // Hex value is: 00000007

    [Description(L"SQL scalar function")]

    FN = 7,

    

    // Hex value is: 00000008

    [Description(L"Assembly (CLR) scalar function")]

    FS = 8,

    

    // Hex value is: 00000009

    [Description(L"Assembly (CLR) table-valued function")]

    FT = 9,

    

    // Hex value is: 0000000a

    [Description(L"Rule (old-style, stand-alone)")]

    R = 10,

    

    // Hex value is: 0000000b

    [Description(L"Replication-filter-procedure")]

    RF = 11,

    

    // Hex value is: 0000000c

    [Description(L"System base table")]

    S = 12,

    

    // Hex value is: 0000000d

    [Description(L"Synonym")]

    SN = 13,

    

    // Hex value is: 0000000e

    [Description(L"Service queue")]

    SQ = 14,

    

    // Hex value is: 0000000f

    [Description(L"Assembly (CLR) DML trigger")]

    TA = 15,

    

    // Hex value is: 00000010

    [Description(L"SQL DML trigger")]

    TR = 16,

    

    // Hex value is: 00000011

    [Description(L"SQL inline table-valued function")]

    IF = 17,

    

    // Hex value is: 00000012

    [Description(L"SQL table-valued-function")]

    TF = 18,

    

    // Hex value is: 00000013

    [Description(L"Table (user-defined)")]

    U = 19,

    

    // Hex value is: 00000014

    [Description(L"UNIQUE constraint")]

    UQ = 20,

    

    // Hex value is: 00000015

    [Description(L"View")]

    V = 21,

    

    // Hex value is: 00000016

    [Description(L"Extended stored procedure")]

    X = 22,

    

    // Hex value is: 00000017

    [Description(L"Internal table")]

    IT = 23,

};

</PRE>

</DIV>

<H2 CLASS="clk" onclick="plusminustgl('SeeAlso_RefBox');"><IMG SRC="../img/minus.gif" WIDTH="16" HEIGHT="16" BORDER="0" CLASS="midmgR" ID="SeeAlso_RefBoxImg" NAME="SeeAlso_RefBoxImg">See Also:</H2>

<A NAME="ANAME_SeeAlso_RefBox"></A><DIV ID="SeeAlso_RefBox" NAME="SeeAlso_RefBox">

&bull; <A HREF="http://msdn2.microsoft.com/en-us/library/System.Enum.aspx" TARGET="_blank">System.Enum</A>

&bull; <A HREF="http://msdn2.microsoft.com/en-us/library/System.Byte.aspx" TARGET="_blank">System.Byte</A>



</DIV>

<SCRIPT LANGUAGE="Javascript1.2">

parent.MENU.ShDiv('SQLReader(1.0.0.0)_Assembly');

parent.MENU.ShDiv('SQLReader.SQLReader_Namespace');

parent.MENU.ShDiv('SQLReader.SQLReader_Enumeration');

parent.MENU.location=parent.MENU.location + '#SQLReader_SQLReader.Object_Type';

CopyRight('Copyright � Paw Jershauge 2008');

CurrentObject('Object_Type Enumeration');

</SCRIPT>

</BODY></HTML>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer
Denmark Denmark

Comments and Discussions