June 11, 2013 at 1:27 am
I had tried to create views for sql server 2008 with tocows software ,but it does not give any valuable results.
June 11, 2013 at 3:12 am
You could create a new view from SSMS. Just right click "views" in Object Explorer and choose "new view". This will open up the design view (which act as some kind of wizard).
June 11, 2013 at 3:36 am
mca.deepak3335 (6/11/2013)
hi on which option should I click in object explorer like databases ,tempdatabase.
- Start SQL Server Management Studio
- connect to the instance where you want to create a view
- expand "databases" in Object Explorer
- expand the database in which you want to create a view
- right click "Views"
- choose "New view..."
- select all the tables/views/functions,etc. you want to use in the view and click [add]
- select all the required fields and give them Alias names if needed
- define filters, sort order, etc
give the defined view a name when saving all changes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply