When on the Script tab for a table and you click the Extended Properties checkbox the script shown will include all the column comments added to the table like shown here:
However when looking at the script for a View checking the Extended Properties checkbox does not then add all the column descriptions to the script. Why does it not work the same was as it does for tables. I am new to Toad for SQL Server, but used Toad for Oracle for over 20 years, so not new to DB development.
It would also be very nice if there was an option when you right click on a Table/View or other object in Explorer the capabilities of Create Like would allow you to select a different Connection/DB/Schema instead of just another DB/schema on the current server. Our Dev, UAT, and Prod DBs are all on different servers and Create Like would be nice to use to move new objects from Dev to UAT, then from UAT to Prod. Toad for Oracle has Create in Another Schema and lets you select the Connection then Schema you want the copy to land in. In Toad for SQL Server I find myself going to the script view, doing a ctrl-a, ctrl-c, navigating to an editor window on the connection I want, ctrl-p, then running the script. If there is a simpler way I have not discovered in Toad for SQL Server please let me know.
