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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

support sql cursors in Warehouse

add support for SQL Cursors, so that we can make better use of metadata / configuration / dynamic sql



Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New
 
KevinFeit
Regular Visitor
I agree with this. Since Warehouse supports primary keys and foreign keys being able to use a cursor would be helpful. For example, looping through INFORMATION_SCHEMA.TABLE_CONSTRAINTS to find all the foreign keys and generate SQL to drop them avoids hard coding.