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"? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200809/1
hi Jay, Jay974 via AccessMonster.com wrote: > 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 <--
Hi Stefan Sorry, not sure what you mean. Can you elaborate pls? Thanks Jay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200809/1
hi Jay, Jay974 via AccessMonster.com wrote: > 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 <--
Thanks Stefan Sorry, I may not have made myself clear. I am looking for this function within Access, not SQL management. Jay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200809/1
hi Jay, Jay974 via AccessMonster.com schrieb: > 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 <--
Jay974 via AccessMonster.com wrote: > 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 -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
