Show create table

[Jay974 via AccessMonster.com]

Hi All

I'm using Access 2003 and MS SQL server. Does anyone know if there is
anything in access which is like the MySQL command "SHOW CREATE TABLE"?

 

[Stefan Hoffmann]

hi Jay,

I'm using Access 2003 and MS SQL server. Does anyone know if there is
anything in access which is like the MySQL command "SHOW CREATE TABLE"?

Take a look at the context menu, when you have selected your table in
the SSMS.


mfG
--> stefan <--

 

[Jay974 via AccessMonster.com]

Hi Stefan

Sorry, not sure what you mean. Can you elaborate pls?

Thanks
Jay

 

[Stefan Hoffmann]

hi Jay,

Sorry, not sure what you mean. Can you elaborate pls?

Open the SQL Server Management Studio, select your table in the object
browser. Open the context menu, select "Script table as".


mfG
--> stefan <--

 

[Jay974 via AccessMonster.com]

Thanks Stefan

Sorry, I may not have made myself clear. I am looking for this function
within Access, not SQL management.

Jay

 

[Stefan Hoffmann]

hi Jay,

Sorry, I may not have made myself clear. I am looking for this function
within Access, not SQL management.

You need to code basically something like that:

http://davidhayden.com/blog/dave/archive/2006/02/09/2795.aspx
http://www.mydatabasesupport.com/forums/sqlserver-programming/203188-using-smo-vba.html


mfG
--> stefan <--

 

[Bob Barrows [MVP]]

Thanks Stefan

Sorry, I may not have made myself clear. I am looking for this
function within Access, not SQL management.

This functioanlity was not included in the version of Access I last used. It
might be A2007, but if it isn't, there are other ways:
http://www.karaszi.com/SQLServer/info_generate_script.asp