<% '============================================================== ' TableEditoR 0.81 Beta ' http://www.2enetworx.com/dev/projects/tableeditor.asp '-------------------------------------------------------------- ' File: te_indexremove.asp ' Description: Removes an index from a table ' Initiated By Hakan Eskici on Nov 17, 2000 '-------------------------------------------------------------- ' Copyright (c) 2002, 2eNetWorX/dev. ' ' TableEditoR is distributed with General Public License. ' Any derivatives of this software must remain OpenSource and ' must be distributed at no charge. ' (See license.txt for additional information) ' ' See Credits.txt for the list of contributors. ' ' Change Log: '-------------------------------------------------------------- '============================================================== %> <% lConnID = request("cid") sTableName = request("tablename") sIndexName = request("idxname") OpenRS arrConn(lConnID) 'Check if the user approved delete and has permissions to delete if (request("sure") <> "") and bFldDel then sSQL = "ALTER TABLE [" & sTableName & "] DROP CONSTRAINT [" & sIndexName & "]" conn.execute sSQL response.redirect "te_tableedit.asp?cid=" & lConnID & "&tablename=" & sTableName end if conn.close set rs=nothing set conn=nothing %>
Home » Connections » "><%=arrDesc(request("cid"))%> » &tablename=<%=server.urlencode(request("tablename"))%>">Edit Table [<%=request("tablename")%>] » Remove Field <% if bProtected then response.write session("teFullName") response.write " (logout)" end if %>

<%=sErr%>Are you sure that you want to delete the index?

Yes  ">No