Discrepency in List tables subroutine
-
I have the following subroutine to list the tables from a selected SQL Server database. In this case AdventureWorks. Private Sub DisplayDatabaseTbls(ByVal tblTables As DataTable) lstTbls.DataSource = Nothing lstTbls.Items.Clear() For Each row As DataRow In tblTables.Rows lstTbls.Sorted = True lstTbls.DataSource = tblTables lstTbls.ValueMember = "Table_Name" lstTbls.DisplayMember = "Table_Name" Next End Sub It retrieves the database tables just fine, but when I open up the same database in Microsoft SQL Server Management Studio Express I noticed that the tables where listed differently. Example: My Subroutine list the tables like this: AWBuildVersion Department Employee While SQl Server Management Studio list them like this: dbo.AWBuildVersion HumanResources.Department HumanResources.Employee Can someone tell me how I can make my subroutine match the SQL Server Management Studio? Thanks in advance, Quecumber256