SQL Sample for MSSQL
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
Life has to be exciting.
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