在ACCESS中,关于rename

xlhuo 2003-10-20 03:12:18

alter table tablename rename column XXX to YYY.

以上在oracle中通过,但在access中通不过,为什么?

...全文

98 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

xlhuo 2003-10-21

打赏
举报

谢谢.还想问一个问题:如何能得到access中表的description和字段的description?

changechange 2003-10-20

打赏
举报

rename在jet sql中不存在，access jetsql不支持此功能，请用adox/dao解决

ado连接数据库access demo vs08 和 vc++ 6.0两个demo vc6.0可能需要修改StdAfx.h中 #import "d:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF") 此路径 dll在vs08的工程里有

在MFC下，采用ADO技术访问access数据库，做的一个很小的学生成绩管理系统。个人觉得对于初学数据库的人来说，是一个很不错的资源。编译时保证头文件stdafx.h中“#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF")”路径正确。本工程具有VC6.0和VS2008两个版本。

#pragma warning(disable:4146) #import "C:\Program Files\Common Files\System\ADO\msado15.dll" named_guids rename("EOF","adoEOF"), rename("BOF","adoBOF") #pragma warning(default:4146) using namespace std; using namespace ADODB;

一、access库函数access函数用于判断当前操作系统用户对文件或目录的存取权限四、rename库函数rename函数用于重命名文件或目录，相当于操作系统

版本 3.50.0070 - 2012/7/20发布。压缩包里带注册码.不要告诉我你们找不到注册码。本人在64位Win7下测试，流畅好用。其他系统未做测试。欢迎大家补充。很多人可能会说，英文版的不好用，其实你要知道，英文字符占1个字节，而中文字符占两个，汉化技术不好的软件都存在容易奔溃的问题。用习惯了，英文版也很cool。本资源只做交流学习使用，请勿作为商业用途。如果您不差钱，请支持正版。以下为Source Insight官方的简介。 Source Insight™ is a project-oriented program editor and code browser, with built-in analysis for C/C++, C#, and Java programs. Source Insight parses your source code and maintains its own database of symbolic information dynamically while you work, and presents useful contextual information to you automatically. Not only is Source Insight a great program editor, but it also can display reference trees, class inheritance diagrams, and call trees. Source Insight features the quickest navigation of source code and source information of any programming editor. Source Insight features quick and innovative access to source code and source information. Unlike many other editor products, Source Insight parses your source code and gives you useful information and analysis right away, while you edit. Always Up-To-Date Information Call Graphs and Class Tree Diagrams Context Sensitive Dynamic Type Resolution Symbol Windows For Each File Automatic Display of Declarations in the Context Window Syntax Formatting - Like Syntax Coloring but More Context-Sensitive Smart Rename Finds References Quickly Mixed Language Editing Keyword Searches Like an Internet Search on Your Code Base Symbolic Auto-Completion Quick Access to All Symbols and Files Project Orientation Team Programming Support Hyper Source Links to Link Compiler Errors Fast Project-Wide Search and Replace Project Window with Multiple Views Integrates with External Compilers and Tools Clip Window for Storing Clipboards and Boiler Plate Code Two-Stage Line Revision Marks and Selective Line Restoration Extensible Document Types and Languages Crash Recovery Offers Full-Time Protection Persistent Workspaces Customizable Menus and Keyboard Windows 7/Vista/XP/2000 Support Special Support for Remote Te

Access

7,712

社区成员

28,799

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章