CREATE PROCEDURE sp_db_tables @DbName nvarchar(20)
AS
declare @str nvarchar(100)SELECT @str = 'select * from '+ @Dbname + '..sysobjects where xtype =''U'' '
exec (@str)
AS
declare @str nvarchar(100)SELECT @str = 'select * from '+ @Dbname + '..sysobjects where xtype =''U'' '
exec (@str)
go
create proc TableDetail
@dbname varchar(20)
as
begin
declare @str varchar(30) select @str = 'use ' + @dbname + '; exec sp_tables'
select @str
exec(@str)
end
TableDetail 'northwind'