Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
selsoft1907
New Member

Generate some views create script

I have a Fabric Data Warehouse. I want to export some views create script into a SQL file. Basically generate script operation. Is it possible ? 
This type of scripts is not working:
SELECT
s.name AS schema_name,
v.name AS view_name,
m.definition
FROM sys.views v
INNER JOIN sys.sql_modules m ON v.object_id = m.object_id
INNER JOIN sys.schemas s ON v.schema_id = s.schema_id
where v.name like '%TEST'
ORDER BY s.name, v.name;

2 ACCEPTED SOLUTIONS
smeetsh
Helper V
Helper V

I ran the script (without the where and order by clause) and that works just fine in SSMS and the fabric UI.

 

The '%TEST' may be invalid. Try running it without the where and see what the results are? PS Keep in mind it is case sensitive.

smeetsh_0-1753159188604.png

 

What is it exactly what you are trying to achieve?

 

Cheers

Hans

View solution in original post

v-dineshya
Community Support
Community Support

Hi @selsoft1907 ,

Thank you for reaching out to the Microsoft Community Forum.

 

Hi @smeetsh  Thank you for your prompt response.

 

Hi @selsoft1907 , As mentioned by @smeetsh , please provide more details about your issue and what you are trying to achieve.

 

Regards,

Dinesh

View solution in original post

3 REPLIES 3
v-dineshya
Community Support
Community Support

Hi @selsoft1907 ,

Thank you for reaching out to the Microsoft Community Forum.

 

Hi @smeetsh  Thank you for your prompt response.

 

Hi @selsoft1907 , As mentioned by @smeetsh , please provide more details about your issue and what you are trying to achieve.

 

Regards,

Dinesh

smeetsh
Helper V
Helper V

I ran the script (without the where and order by clause) and that works just fine in SSMS and the fabric UI.

 

The '%TEST' may be invalid. Try running it without the where and see what the results are? PS Keep in mind it is case sensitive.

smeetsh_0-1753159188604.png

 

What is it exactly what you are trying to achieve?

 

Cheers

Hans

I fix the issue. The reason behind ssms. When I run this script it return space for view definition column. However when I run under fabric portal it returns data. Maybe reason is permissions.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.