Geek asks and answers

Generate a schema from stored procedures

Is there a way to chart the schema from a SQL Server database using the stored procedures of that database?

I do not mind if I have to use external software.

+3
source share
3 answers

You can try playing with CodeSmith Generator . It SchemaExplorer Discovery API API allows you to programmatically access database items for a given database and do something creative with it. However, it will still be logically difficult to redesign the circuit / diagram in this way.

+1
source

SQLCLR, Scripter Class SMO.

update: , .

information_schema, syscomments . , " " SQL-. , , , .

0

, .

, .

:

  • proc
  • , , ..,

, :

  • see what permissions you have in SSMS, etc.
  • see the insides if you have VEIW DEFINITION rights.

Change after clarification

Unable to use script implied aspects (such as missing foreign keys) schemes from code

0
source

More articles:


All Articles