Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Rename SQL Table thru ASP		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts
Posted - 29 June 2001 :  15:35:12  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I need to rename my SQL table, but dont have time to go home to Enterprise Manager, can this be done thru asp script?

Brad

camusflage
Starting Member

USA
26 Posts
Posted - 05 July 2001 :  17:57:52  Show Profile
set cn = server.createobject("adodb.connection")
cn.open (blah blah blah)
cn.execute "exec sp_rename 'objectname', 'newobjectname'"
cn.close
set cn=nothing
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07