Create script of SQL 05 DB

[emmim44]

Do you know how to generate a script that will get all the FK,PK,indexes,views,contsraints of a SQL 05 DB?


I am using Rapid SQL...
Any solution....Thank you.

[Dan_Bracuk]

google "ms sql 2005 system tables"

[JR__Bob__Dobbs-qSBHQ2]

Take a look at the sys.objects and sys.indexes views
http://msdn.microsoft.com/en-us/library/ms189783(SQL.90).aspx

[JR__Bob__Dobbs-qSBHQ2]

emmim44,

Are you trying to get creation scripts for these objects or just check for existence in the database?

[emmim44]

get creation scripts is needed...

[JR__Bob__Dobbs-qSBHQ2]

To get the definition for views (functions, and stored procedures) you can query sys.sql_modules.

USE AdventureWorks

SELECT definition
FROM sys.sql_modules
WHERE OBJECT_NAME(object_id) = 'vEmployee'


If you have access to Microsoft SQL Server Management Studio you can use it to generate scripts.

http://msdn.microsoft.com/en-us/library/ms178078(SQL.90).aspx

[emmim44]

I used SQL Management studio it does create script but since the presedence of tables are important.. the created script throws lots of error...There are lots of circular constraints on tables...