Is there an equivalent table or view in SQL Azure for syscomments?  I use syscomments all the time to find references and dependencies to stored procedures and views, and I just realized there is no syscomments object

Today, no. However, from a dependencies point of view, the SQL Server documentation actually states that sys.sql_dependencies will be removed from a future version. The recommended procedure is sys.sql_expression_dependencies which works both in SQL Server and SQL Azure.

I know this was a 4 year old post, but I had to modify my stored procedure generator to work on Azure SQL and the item that worked for me is:

sys.all_sql_modules and there is also sys.sql_modules.

this is closer to SysComments as the only other change I had to make was querying of the field object_id instead of id.

Just thought I would add this in case anyone else finds this since this is the top search result now for SysComments on Azure SQL.

• Edited by DataJuggler 12 hours 26 minutes ago

I know this was a 4 year old post, but I had to modify my stored procedure generator to work on Azure SQL and the item that worked for me is:

sys.all_sql_modules and there is also sys.sql_modules.

this is closer to SysComments as the only other change I had to make was querying of the field object_id instead of id.

Just thought I would add this in case anyone else finds this since this is the top search result now for SysComments on Azure SQL.

• Edited by DataJuggler 12 hours 16 minutes ago

I know this was a 4 year old post, but I had to modify my stored procedure generator to work on Azure SQL and the item that worked for me is:

sys.all_sql_modules and there is also sys.sql_modules.

this is closer to SysComments as the only other change I had to make was querying of the field object_id instead of id.

Just thought I would add this in case anyone else finds this since this is the top search result now for SysComments on Azure SQL.

• Edited by DataJuggler Friday, March 20, 2015 6:50 PM

I know this was a 4 year old post, but I had to modify my stored procedure generator to work on Azure SQL and the item that worked for me is:

sys.all_sql_modules and there is also sys.sql_modules.

this is closer to SysComments as the only other change I had to make was querying of the field object_id instead of id.

Just thought I would add this in case anyone else finds this since this is the top search result now for SysComments on Azure SQL.

• Edited by DataJuggler Friday, March 20, 2015 6:50 PM

I know this was a 4 year old post, but I had to modify my stored procedure generator to work on Azure SQL and the item that worked for me is:

sys.all_sql_modules and there is also sys.sql_modules.

this is closer to SysComments as the only other change I had to make was querying of the field object_id instead of id.

Just thought I would add this in case anyone else finds this since this is the top search result now for SysComments on Azure SQL.

• Edited by DataJuggler Friday, March 20, 2015 6:50 PM

I know this was a 4 year old post, but I had to modify my stored procedure generator to work on Azure SQL and the item that worked for me is:

sys.all_sql_modules and there is also sys.sql_modules.

this is closer to SysComments as the only other change I had to make was querying of the field object_id instead of id.

Just thought I would add this in case anyone else finds this since this is the top search result now for SysComments on Azure SQL.

• Edited by DataJuggler Friday, March 20, 2015 6:50 PM

I am glad I commented on this, every time I needed now Google knows just where to find it.