>Dear Viv Phillips
>Thank you for your reply,
>then how to copy views from one database to another ?
>
>Please advise.

Hi,
Not sure. You could probably do it manually be opening the view in the source database and using the code shown in the 'View SQL' as a basis for a 'CREATE VIEW' command executed against the target database. Someone else may have a better solution

HTH,
Viv