#{茶男與藍牌}
Currently viewing the tag: "SQL"
select * from SYSOBJECTS where TYPE = ‘U’ order by NAME
equals to the one in mysql
show tables
Or we can use sp_help, for exmple:
exec sp_help database_name
refer to http://msdn.microsoft.com/en-us/library/aa933429.aspx
-
Articles
- February 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
-
Meta
