I need to modify my client's database(he is using SQL Server 2005). I have the connection string so that i can connect to the database.
Is there a way that i can learn the table names that the database has and even the data types that the tables contain ?
Or do i have to ask my client to tell me the table names and the column types/names ?
It would make my life a lot easier if there was a sql query that will retrieve table information from a database.