best way to extract T-SQL from ADP 1

[psimon88]

Hello

I am more familiar with MDB files, but there has to be a way to do this.

I have a MS Access 2003 .ADP file and would like to get the T-SQL for some views without cutting and pasting en masse.

I don't see a 'documenter', as I would in an MDB. Anyone with any suggestions?

Thanks.

ps

 

[cmmrfrds]

Are you familiar with the system tables that are included with every database in sql server. Some of the tables are sysobjects, syscolumns, syscomments, etc......

Select * from sysobjects where xtype = 'U'
this will give information on user tables.

I believe views would be xtype of V. The view script should be in syscomments so join sysobjects to syscomments to get this information. Do some investigation on the system tables.

 

[psimon88]

Thanks. I will try.

 

[cmmrfrds]

You can also get the information from the INFORMATION_SCHEMA.

select Table_name,
view_definition
from INFORMATION_SCHEMA.VIEWS