參考資料:http://msdn.microsoft.com/zh-tw/library/ms177596.aspx
use [YourDB]
select * from sysobjects where xtype = 'U' order by name
/*
U = 使用者資料表(table), V = 檢視(view) , P = 預存程序(store procedure)
*/
use [YourDB]
select * from sysobjects where xtype = 'U' order by name
/*
U = 使用者資料表(table), V = 檢視(view) , P = 預存程序(store procedure)
*/
留言