Hi I used following coding to add all tables into arraylist, But i got error...."Invalid Object Name syss.tabe"
Dim con As New SqlConnection("Server=VAXGEN-3;Database=Northwind;uid=sa;pwd=vgn")
con.Open()
Dim cmm As New SqlCommand("select name from sys.tables", con)
Dim da As New SqlDataAdapter(cmm)
Dim dt As New DataTable
da.Fill(dt)
Dim dv As New DataView(dt)
Dim arr As New ArrayList
arr.Add(dv)
con.Close()
In QueryAnalyzer
I executed
exec SP_Tables
I can see Table_Qualifier,Table_Owner,Table_Name,Table_Type,Remarks
How can fetch Only Table_Name
|
| Author: Arun Kumar 30 Aug 2008 | Member Level: Gold | Rating:  Points: 1 |
select name from sys.tables where Table_Type='table'
try this query.
|
| Author: Sandeep Chougule 30 Aug 2008 | Member Level: Gold | Rating: Points: 6 |
sql 2005
select name from sys.tables
this querey wiil fetch all tables for ur database
Plz check ur spell in codding
sql 2000 and sql 2005
select Name from Sysobjects where Xtype = 'U' order by Name
|