Sorry for posting an ACCESS question but...
Does anyone know how to generate a CREATE Table statement from the object like you do in SQL Server.
Right click object> Generate SQL ??Access doesn't support a DDL. You need to issue Access Basic commands in a module to create database objects.
Post your question on the Access forum.|||yes, access supports DDL
HOWTO: Common DDL SQL for the Microsoft Access Database Engine (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q180/8/41.asp&NoWebContent=1)
i will often take a CREATE TABLE statement that i have developed for sql server or mysql or whatever, and do some text editing on it to change the datatypes, etc., and then just run it in a new query in SQL View, rather than using the New Table Design View wizard
:cool:|||I did not know that!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment