select name from sysobjects where type='U'/* name ------------------------------------- titleauthor stores sales roysched discounts jobs pub_info employee 税率表 authors publishers titles(所影响的行数为 12 行)*/
select name from sysobjects where xtype='u' --忘加条件了,呵呵!
use db go select name from sysobjects where type='U'
select name from sysobjects
name
-------------------------------------
titleauthor
stores
sales
roysched
discounts
jobs
pub_info
employee
税率表
authors
publishers
titles(所影响的行数为 12 行)*/
select name from sysobjects
where xtype='u'
--忘加条件了,呵呵!
go
select name from sysobjects where type='U'
但我希望是在winform里写这个
关键是这个指定数据库名怎么写??
比如:在数据库student里的所有表名
哪都一样
select name from sysobjects where xtype='u'
select name from sysobjects where type='U'