You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please check DbSchema Help / Output logs for errors.
09:00:21 Import task done.
09:00:21 REVERSE ENGINEERED 13 TABLES FROM AzureSQL.
09:04:00 > exportSchemaScript
09:04:00 Dialog Export Schema & Data
09:04:19 > chooseFile
09:04:28 > ok
09:04:28 Dialog Select Schemas & Tables to Include
09:12:55 > outputLogs
09:12:55 Dialog Output Logs
Please include the DbSchema version, operating system and used database
DbSchema: 9.0.0
Azure SQL
The steps to reproduce this issue
Create functions, which depend on each other
CREATE OR ALTER FUNCTION security.ufnHasDatasetAccess(@DatasetID int)
RETURNS TABLE
WITH SCHEMABINDING
AS
RETURN
select1as able fromsecurity.ufnHasIndirectAccess(@DatasetID)
GO
CREATEFUNCTIONsecurity.ufnHasIndirectAccess(@ParentID int)
RETURNS TABLE
WITH SCHEMABINDING
AS
RETURN
SELECT1as able
GO
Go to DBSchema tool: Schema -> Generate Schema DDL. Produced ordering is incorrect, since security.ufnHasDatasetAccess gets put first instead of schema.ufnHasIndirectAccess
The text was updated successfully, but these errors were encountered:
DbSchema: 9.0.0
Azure SQL
Create functions, which depend on each other
Go to DBSchema tool: Schema -> Generate Schema DDL. Produced ordering is incorrect, since
security.ufnHasDatasetAccess
gets put first instead ofschema.ufnHasIndirectAccess
The text was updated successfully, but these errors were encountered: