Is there a free web based tool to view the database schema and its properties
Is there a free web based tool (I prefer Microsoft because I have an MSDN
account) to view the database schema and its properties? I'm currently
using Visio but I dont know if it's possible in Visio to do the following:
View the database schema that I will upload in a Sharepoint workspace.
If I click the name of the Database table, it will either pop up a small
window with its database properties and column description or another
window will pop up with its database properties and column description.
For example I have a Schema table interface composed of a profile and time
tables.
THESE ARE JUST EXAMPLES.
ProfileDim table
Profile ID number(10)
FirstName varchar (20)
MiddleName varchar (20)
LastName varchar (20) TimeDim Table
DateHired datetime---------------EmployeeStartDate datetime,
Date_Name nvarchar(50),
Year datetime,
If I click the name "TimeDim" it will take me to another page where I can
see the database properties written below and the description of each
column. I prefer not to use MS excel or word. I want a tool that I could
edit, delete in case I want to add another column, change the data type
and change the name etc.
TimeDim table
COLUMN NAME DATA TYPE ALLOW NULLS DESCRIPTION
EmployeeStartDate datetime, Unchecked "START DATE OF THE
EMPLOYEE"
Date_Name nvarchar(50), Checked "CURRENT DATE NAME"
Year datetime, Checked "NAME OF THE CURRENT
YEAR"
No comments:
Post a Comment