USE datamigrationtest SELECT * FROM sys.Tables;
string str = "USE " + strintTable + " SELECT * FROM sys.Tables";
string str = "USE " + strintTable + " SELECT * FROM sys.tables";
EXEC sp_tables @table_type = "'TABLE'"
INFORMATION_SCHEMA
SELECT * FROM information_schema.tables
SELECT * FROM sysobjects WHERE xtype='U'
SELECT * FROM datamigrationtest.sys.Tables;
string str= "USE DbPerson;"; str += "SELECT table_name FROM information_schema.tables WHERE table_type = 'base table';";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)