var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL db table attributes display with ASP
Using ASP does anyone know how to or have a good tutorial on how to retireve the database table names, column names and data format with a SQL Server database?
Any help would be greatly appreciated.
You plz try with sysobjects table wherein you can get maximum
info about the table in that db.
For example to get the no of columns
rsobj.open "select info from sysobjects where name="tablename"",connobj
Response.write("No of columns in "tablename" is " + rs("info"))
is that anything else i could do
if this is not the one you need plz lemme know.
Re: SQL db table attributes display with ASP
There's a FREE tool at 1ClickDB.com that handles web based database table management. They also sell a commercial version.
The 1ClickDbFree version provides some excellent insight into how to query Access, MSSQL and Oracle databases for table names and details.
Go to 1clickbd.com and look in the upper right corner for the Free tool link.
Yes, you can do this:
select * From MyDBName.information_schema.columns
Replace MyDBName with the database you wish to search. That will give you the 411 on all the tables in that database.
Personally, I recommend you make a new table called "DbSchema" and manually enter that information there, and keep it updated.